Home » SQL & PL/SQL » SQL & PL/SQL » doubt on joins (oracle 9i)
doubt on joins [message #320147] Wed, 14 May 2008 03:14 Go to next message
Messages: 38
Registered: February 2008
Location: Bangalore

I have 2 tables .Table A is parent table and B is the child table .I must write a query using both the tables and i want to retrieve only unmathced rows from table A.How do i do this?

Thanks in advance
Re: doubt on joins [message #320155 is a reply to message #320147] Wed, 14 May 2008 03:30 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
With a NOT IN or NOT EXISTS sub-query.

Ross Leishman
Previous Topic: Printing the spooled file
Next Topic: full outer join
Goto Forum:

Current Time: Sun Oct 23 15:33:00 CDT 2016

Total time taken to generate the page: 0.09072 seconds