Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL query puzzle
Hi,
Use "distict" for 1 and 2. For three you can do outer join and show all that have null in skill_hist table based on the condition you specify in your where clause. Received on Fri Jan 04 2002 - 11:40:13 CST