|
Kannan_JrDBA
Starting Member
USA
4 Posts |
 Posted - 03/19/2013 : 21:51:37
|
Hi,
I need to write query to get records with below combination
PONUM LINETYPE
P-001 ITEM
P-001 SERVICE
P-002 SERVICE
P-002 MATERIAL
P-002 ITEM
P-003 ITEM
p-003 MATERIAL
p-004 ITEM
p-005 MATERIAL
p-006 SERVICE
.
.
.
.
I have to get the PONUM for combination of (SERVICE, ITEM, MATERIEL) or (SERVICE and ITEM) or (SERVICE and MATERIAL).
Expected output:
P-001 ITEM
P-001 SERVICE
P-002 SERVICE
P-002 MATERIAL
P-002 ITEM
Could some one please help me to write the SQL.
Thanks
Kannan.
Thank you
Kannan |
|
Query Help Need
