I hope you can help me.
I am trying to generate a report using 3 tables - sttakehm, sttakedm and stquem.
I wrote below query but it is giving all values of unit_cost, I only need the unit cost which matches stquem.sequence _number=sttaked m.queue_referen ce and adjustment quantit.
The key is sequence number is in one line with Kind = "C" and adjustment quanity is on second line with Kind = "B".
I need this pretty urgent, I hope you can help me
SELECT sttakedm.card_n umber, sttakedm.produc t_code, sttakedm.adjust ment_quantit, sttakedm.expect ed_quantity, sttakehm.wareho use, stquem.unit_cos t, sttakehm.descri ption1
FROM scheme.sttakedm sttakedm
INNER JOIN scheme.sttakehm on sttakehm.card_n umber = sttakedm.card_n umber
LEFT OUTER JOIN scheme.stquem on sttakehm.wareho use=stquem.ware house
WHERE sttakehm.card_n umber = sttakedm.card_n umber AND sttakedm.card_n umber='C03323' AND (stquem.sequenc e_number=sttake dm.queue_refere nce OR (sttakedm.kind = 'B' OR sttakedm.kind = 'C')) AND sttakedm.produc t_code = stquem.prod_cod e AND sttakehm.wareho use=stquem.ware house