Thank you guys very much for responding! wow. I should have been more clear though. This is actually for a database class I am taking, and can not change the tables. We are using oracle mySQL. Also, I was able to get this out of my professor " My solution involved a "nested select statement" and the other solution involved an outer join." Thank you guys though! I really do appreciate the help.
|