G Guest Nov 14, 2007 #1 I'm linking tables in a query and as I do so, the records are duplicated. What do I need to do to prevent this from happening?
I'm linking tables in a query and as I do so, the records are duplicated. What do I need to do to prevent this from happening?
G Guest Nov 14, 2007 #2 Depends what your query is, post the SQL. Essentially you need a join column that links the tables. You may also need SELECT DISTINCT instead of just SELECT. -Dorian
Depends what your query is, post the SQL. Essentially you need a join column that links the tables. You may also need SELECT DISTINCT instead of just SELECT. -Dorian