Monday, August 29, 2011

One OV with Multiple OPs


SELECT PRMCU, PRDOC, COUNT(DISTINCT(PRDOCO))
  FROM PRODDTA.F43121
 WHERE PRDCT = 'OV'
 GROUP BY PRMCU, PRDOC
HAVING COUNT(DISTINCT(PRDOCO)) > 1
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)