Basically what is happening is that one row in one of the tables is being joined to two rows in another table. The two rows that are being joined are probably unique, but you aren't including the column/s that make them unique in the query (I don't know for sure which tables are causing it because you didn't give input data).You need to either add those column/s to the query (if you do in fact need them) or add the DISTINCT keyword to exclude the duplicates.For example:create table #Customers(CustomerID int,CustomerName varchar(20))create table #Orders(OrderID int,CustomerID int,OrderDate datetime)insert #Customersselect 1, 'Mickey Mouse' union allselect 2, 'Donald Duck' union allselect 3, 'Goofy'insert #Ordersselect 1, 1, '1/1/2007' union allselect 2, 1, '1/1/2007' union allselect 3, 2, '1/2/2007' union allselect 4, 2, '1/2/2007' union allselect 5, 3, '1/3/2007' union allselect 6, 3, '1/4/2007'--Query with duplicatesselect C.CustomerName, O.OrderDatefrom #Customers C inner join #Orders O on C.CustomerID = O.CustomerID--Query 1 without duplicatesselect C.CustomerName, O.OrderID, O.OrderDatefrom #Customers C inner join #Orders O on C.CustomerID = O.CustomerID--Query 2 without duplicatesselect distinct C.CustomerName, O.OrderDatefrom #Customers C inner join #Orders O on C.CustomerID = O.CustomerIDdrop table #Customersdrop table #Orders