Tuesday, November 1, 2011

Identify *OP items where QTY <> 0

SELECT * FROM proddta.F4101, proddta.F41021 WHERE lipqoh <> 0 AND liitm = imitm AND imlitm LIKE '%*OP%'

No comments:

Post a Comment