I am trying to get a distinct query running based on an INNER JOIN query. However I get about 12 errors when I run the query
SELECT Distinct Cust.AName, PWMain.CustRef, Cust.*FROM Cust INNER JOIN PWMain ON Cust.AName = PWMain.ContactName
Does anyone know what I can do to get around this? I basically want all distinct rows from cust based on AName and only the CustRef added to the row where there is a match as stated in the T-SQL. ThanksToni