(see my last post for clarification)
I'm learning SQL, and this is probably very easy, BUT-
So lets say I have a table('supply') in my database of suppliers('sp') and part numbers ('pnum').
How would I do something like: "Display all supplier/part pairs for which the supplier has never shipped the part."
I have some more questions... I will try to figure them out once i get this answer... but I may post again!
THANK YOU! (in advance)
I'm learning SQL, and this is probably very easy, BUT-
So lets say I have a table('supply') in my database of suppliers('sp') and part numbers ('pnum').
How would I do something like: "Display all supplier/part pairs for which the supplier has never shipped the part."
I have some more questions... I will try to figure them out once i get this answer... but I may post again!
THANK YOU! (in advance)