Get unique value in INNER JOIN in SQL server 2005 query

[salon]

I am joining two tables with INNER JOIN and I am getting duplicate entries. I used DISTINCT but its not working. Do we have some other keywords for the same? Thanks in advance,

[Alsvha]

You do not get duplicate entries if you can't DISTINCT them away. At least one of the values in your SELECT list differs from the others, making the rows different. DISTINCT will remove "duplicated" rows.

--------------------------- Blogging about SQL, Technology and many other things

[Blue_Boy]

try to use TOP 1

---

I Love T-SQL "Don't torture yourself,let the life to do it for you."

[Vinay Dornala]

Hi, Try in this way, I am not sure this will resolve your question. Distinct will impact on performance ( number of cpu reads) WHILE EXISTS (select * FROM Table1 GROUP BY col1,col2.., HAVING count(*) > 1) BEGIN SET ROWCOUNT 1 DELETE e FROM Table1 e.empid WHERE EXISTS (select empid from @tab i where i.empid = e.empid AND i.name = e.name GROUP BY i.empid, i.name HAVING count(*) > 1) SET ROWCOUNT 0 END