01.strSQL = " select e3.*,e.*,d.*,j.invno, j.dcltype,j.doctype, j.cleardate, j.cleartime,j.status,j.timestamp "
02.strSQL += " ,j.ft2date, dinv.invdate,dinv.totalinv,sum(e3.basevatamt) as basevat "
03.strSQL += " from dclheader d "
04.
05.strSQL += " left join job j on j.jobno=d.jobno"
06.strSQL += " left join dclinv dinv on dinv.invno=j.invno "
07.strSQL += " left join einv3 e3 on e3.invno=dinv.invno"
08.strSQL += " left join exporter e on e.code=j.importer"
09.strSQL += " where e3.verno = " + " '" + txtVerNo.Text.Trim + "'"
10.strSQL += " and d.jobno=" + "'" + txtRefNo.Text.Trim + "'"
11.strSQL += " GROUP BY d.jobno"
