Post the query you are using. Usually you can use an aggregate function or row_Number function to remove the duplicate. Here is a simplified example - you could do something like that. create table #Emp(id int, name varchar(32));create table #EmpPhones(empid int, phonenumber varchar(32));insert into #Emp values (1,'JK'),(2,'U2');insert into #EmpPhones values (1,'2125551212'),(1,'2035551212'),(2,'9145551212');-- gives multiple rowsselect id,name,phonenumberfrom #Emp e inner join #EmpPhones ep on ep.EmpId = e.id;-- picks one phone number and shows only one row per employeeselect id,name,phonenumber from( select id,name,phonenumber, row_Number() over(partition by id order by phonenumber) as RN from #Emp e inner join #EmpPhones ep on ep.EmpId = e.id) s where RN = 1;drop table #Emp, #EmpPhones;
Left join cause duplicate rows
Posted - 2013-04-18 : 17:47:15
