Thursday, September 29, 2011

Standard Vs Avg Cost


SELECT t1.C2ctry, t1.C2fy, t1.C2itm, t1.C2litm, t1.C2mcu, t3.c0mmcu, t1.C2ledg, t2.Coledg,  t1.C2uncs/10000, t2.Councs/10000  FROM qadta.F554105 t1, qadta.F4105 t2, qadta.F554103 t3
WHERE
t1.c2ledg = '02' AND
t2.coledg = '07' AND
t1.c2itm = t2.coitm AND
t1.c2mcu = t2.comcu AND
t1.c2pn = 8 AND
--t2.c2pn  = 8 AND
--t1.c2uncs <> t2.c2uncs AND
t1.c2mcu LIKE '%310%' AND
t1.c2mcu = t3.c0mcu
ORDER BY t1.C2ctry, t1.C2fy, t1.C2itm, t1.C2litm, t3.C0mmcu, t1.c2mcu;

No comments:

Post a Comment