How do you cleanup dupe rcords in a query.

H

Huskerboy

I have a query that is giving me results from table1.name = table2.name and table1.name=table3.name. Table1 is the main table 1 is the main table with all names in the company in it. Table 2 has only certain names in it and Table 3 only has some names in it. I need the names that match from table2 and table3 but I need to fine a way to cleanup duplicate names in the same query. If the name is in Table2 and Table3 I get to instances of the name. I only want to see on instance of the name. Can some one help me.

Thanks in Advance
 
Top