Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Join Query without using NOT IN subquery

This is a discussion on Join Query without using NOT IN subquery within the SQL forums, part of the Databases category; Question asked by visitor josephkm5 I want to Select all records from Master table which is not in Detail table using join, without using 'NOT IN' subquery. Master - Detail tables ...

Geeks Talk > Databases > SQL Join Query without using NOT IN subquery

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   02-28-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

Join Query without using NOT IN subquery Question asked by visitor josephkm5 I want to Select all records from Master table which is not in Detail table using join, without using 'NOT IN' subquery. Master - Detail tables has foreign key replationship.

The Following User Says Thank You to Geek_Guest For This Useful Post:

sharma.amit

Sponsored Links

#2 (permalink)   03-07-2007

madhumnc Junior Member   Join Date: Jan 2007 Posts: 2 Thanks: 0 Thanked 1 Time in 1 Post

Re: Join Query without using NOT IN subquery try 'MINUS' operation

The Following User Says Thank You to madhumnc For This Useful Post:

sharma.amit

Geeks Talk > Databases > SQL

« Display record ordered by the day of the week | Difference between the two open SQL statements »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Meaning of Join and Link	JobHelper	Seibel	2	05-08-2007 07:36 AM
Capture the reject records from a join stage	infinity	Data Warehousing	0	02-28-2007 01:33 PM
Which to use - A join or a look-up	infinity	Data Warehousing	0	02-28-2007 01:32 PM
Using Join	bvani	Oracle	6	02-12-2007 03:30 PM
Need Help-re-entering the job market wish to join the IT industry	Jassi10	Career Advice	3	12-20-2006 11:48 PM

All times are GMT -4. The time now is 07:08 PM.