select A.gdssalecode as '商品编码',
A.printprice as '价格',
SUM(A.pamount) as '打印数量'
from inf_gdscode B,
inf_supplier C,
(select a.gdssalecode as gdssalecode,
a.printprice as printprice,
a.pamount as pamount
from (select gdssalecode,
printprice,
SUM(printamount) as pamount
from sys_labelprint_log
where printdate >= '2015-11-01'
and printdate <= '2015-11-30'
group by gdssalecode,printprice) a
left join (select gdssalecode,saleprice
from inf_salecode) b on a.gdssalecode = b.gdssalecode
left join (select gdssalecode,oldsaleprice
from bil_changedtl
group by gdssalecode,oldsaleprice) c on a.gdssalecode = c.gdssalecode
where a.printprice <> b.saleprice
and a.printprice <> c.oldsaleprice
group by a.gdssalecode,
a.printprice,
a.pamount) A
where B.suppliercode = C.suppliercode
and B.gdscode = LEFT(A.gdssalecode,8)
and B.suppliercode = '101510'
group by A.gdssalecode,
A.printprice
order by A.gdssalecode
商品编码 价格 数量
1201009400 6.00 1 这条记录应该是过滤的记录，属于C.oldsaleprice这列数据的记录
1201010900 17.00 2
1201014800 21.60 1
1201014800 30.00 1
1201019000 16.00 1
1201024200 12.00 2
