How do I get this query to show only one result if the Contact_ID may have more than one customer, associated process or task associated with it? I have tried adding DISTINCTROW to it but it doesn't seem to have any affect. I have also tried TOP 1 but this doesn't do what I need it to either.
SELECT Main_Table.Contact_ID, Main_Table.Full_Name, Main_Table.Contact_type, Customer_Table.Customer, Team_Table.Team, Associated_Process_Table.Associated_Process, Task_Table.Task
FROM (((Main_Table LEFT JOIN Customer_Table ON Main_Table.Contact_ID = Customer_Table.Contact_ID) LEFT JOIN Associated_Process_Table ON Main_Table.Contact_ID = Associated_Process_Table.Contact_ID) LEFT JOIN Task_Table ON Main_Table.Contact_ID = Task_Table.Contact_ID) LEFT JOIN Team_Table ON Main_Table.Contact_ID = Team_Table.Contact_ID;