Record Duplication When Creating Queries

G

Guest

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query results in duplicate data,help? 3
Query duplicate values 1
Unique values in two fields in query 1
Large rowset 1
Any way to automate set intersection discovery? 2
Duplicate Returns. 3
Why are there duplicates in my query results? 2
Duplication of records in query? 2

Top