[b]Question asked by visitor josephkm5[/b]
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.
Printable View
[b]Question asked by visitor josephkm5[/b]
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.
try 'MINUS' operation