Posted by amit.tzafrir on 10/01/00 11:39

Did you try to use DISTINCT to remove the duplicates?
SELECT DISTINCT tab2.* FROM tab2 INNER JOIN tab1 ON tab2.N2 = tab1.N1

• Next in forum: Chain of triggers - how to break it?
• Prev in forum: Re: Removing Duplicates rows from Inner Join
• Thread view: Re: Removing Duplicates rows from Inner Join

[Reply to this message]