Hey guys, i've got a table zeqld(key, equipment, salesord, material). There are duplicate equipments and salesords. I need to do what seems to be a simple thing although I'm not familiar with how exactly do it.
I need to get all equipments that have more then 1 salesord.
In essence, here is an example scenario
equipment order material
1 A mat1
1 A mat2
2 B mat3
2 B mat4
2 C mat5
3 D mat6
3 E mat7
4 F mat8
4 F mat9
I would want to see
equipment 2 because order B and C are different and part of equipment 2 AND equipment 3 because sales orders D and E are different.
I'm pretty sure i need a group by clause although its just not coming together. Any help would be greatly appreciated.
Thanks much,
-Shaunt
I need to get all equipments that have more then 1 salesord.
In essence, here is an example scenario
equipment order material
1 A mat1
1 A mat2
2 B mat3
2 B mat4
2 C mat5
3 D mat6
3 E mat7
4 F mat8
4 F mat9
I would want to see
equipment 2 because order B and C are different and part of equipment 2 AND equipment 3 because sales orders D and E are different.
I'm pretty sure i need a group by clause although its just not coming together. Any help would be greatly appreciated.
Thanks much,
-Shaunt