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

[Back to original message]