|
发表于 2014-7-3 17:18:49
|
显示全部楼层
SELECT log.log_dt, log.log_time, log.invs_num, log.invs_cd, log.cus_id, rtrim(log.updt_by), log.prod_cd, log.prod_qty, log.order_qty, log.unit_prs, log.discount, log.real_qty, log.log_cost, ISNULL(log.prod_comp,''), log.ord_type, log.nt_num, log.prod_duty, log.ut_desc, log.whs_num, log.tax_ind, cus.cus_id, cus.cus_nm, isd.order_no, isd.str_num FROM invt_log log left Join customer cus on (cus.cus_id = log.cus_id) left Join ins_data isd on (isd.invs_num = log.invs_num) left Join invoice ins on (ins.invs_num = log.invs_num) and ins.invs_cd = 1 WHERE isnull(log.log_dt,0) >= 77924 and isnull(log.log_dt,0) <= 77985 and isnull(log.prod_qty, 0) <> 0 ORDER BY log.log_dt, log.log_time |
|