 |
|
Code (VB.NET)
strSQL = " select e3.*,e.*,d.*,j.invno, j.dcltype,j.doctype, j.cleardate, j.cleartime,j.status,j.timestamp "
strSQL += " ,j.ft2date, dinv.invdate,dinv.totalinv,sum(e3.basevatamt) as basevat "
strSQL += " from dclheader d "
strSQL += " left join job j on j.jobno=d.jobno"
strSQL += " left join dclinv dinv on dinv.invno=j.invno "
strSQL += " left join einv3 e3 on e3.invno=dinv.invno"
strSQL += " left join exporter e on e.code=j.importer"
strSQL += " where e3.verno = " + " '" + txtVerNo.Text.Trim + "'"
strSQL += " and d.jobno=" + "'" + txtRefNo.Text.Trim + "'"
strSQL += " GROUP BY d.jobno"
ทำไมค่า sum(e3.basevatamt) มัน sum ออกมาไม่ตรงตาม where e3.verno = " + " '" + txtVerNo.Text.Trim + "'" อะครับมัม sum ออกมาหมดเลย
Tag : VB.NET
|
|
 |
 |
 |
 |
Date :
2012-04-11 15:54:11 |
By :
aorestless |
View :
932 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |