Hi guys, I believe this is a left join question (though I�m not 100% sure) I have a table with the info below. Some data is not included in the second table but I still want the user to know about it. Can anyone tell what is the sql command for that? Thanks
You're right it's an OUTER JOIN problem (left or right, depending on how you order your query). To complicate it, you've got a SUM across ID for one the tables. Not too hard, but challenging enough to be interesting.
I tend to use the Oracle non-standard syntax for these, which is:
I'm too brain-fried this evening to work out the standard syntax; if you need that, the above should give you a running start...