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
sharathmpatil
Messages: 38
Registered: February 2008
Location: Bangalore
Member

HI,
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
rleishman
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
With a NOT IN or NOT EXISTS sub-query.

Ross Leishman
Previous Topic: Not able to write the data into output file
Next Topic: full outer join
Goto Forum:
  


Current Time: Sun Aug 20 22:01:09 CDT 2017

Total time taken to generate the page: 0.01254 seconds