Posted by asgars on 10/01/76 11:39

i have two tables, tab1 having N1 col and tab2 N2 col. now N1 is subset
of N2.
I need the information from tab2 (having N2) of all rows having the
matching entry in N1 in tab1.
For this i am using Inner Join on cols N1 and n2. But result is giving
duplicate rows. Can anyone suggest how do u i remove those duplicate
rows? or may be a better way to do the above work... Thanks

• Next in forum: Removing Duplicates rows from Inner Join
• Prev in forum: Testing UDFs with TSQLUnit
• Thread view: Removing Duplicates rows from Inner Join

[Reply to this message]