Posted by markc600 on 10/01/75 11:39

Sounds like you should be using EXISTS
rather than a join

SELECT * FROM tab2
WHERE EXISTS (SELECT * FROM tab1 WHERE tab1.N1=tab2.N2)

• Next in forum: Re: Removing Duplicates rows from Inner Join
• Prev in forum: Removing Duplicates rows from Inner Join
• Thread view: Re: Removing Duplicates rows from Inner Join

[Reply to this message]