Answer for:

SQL Server: Join two tables returning only one row from the second table

Message 3 of 6

View entire thread
0 Votes

Thank you for the reply.

Your query will return two (2) rows, since there are two records with IDadd = 1001 in TABLE2. What I want is to get only 1 row from TABLE2 and join it to TABLE1 so I could return only a single row.