limiting returns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm running a query on a table and the records that are returned are often
duplicated (returned more than one). This may be to general a question, but
what causes this?
 
Are you joining two or more tables in the query? or does the query have more
than one table in the FROM clause and the tables are not joined in any way?

Post the SQL statement of the query and that will help us see what might be
causing the result.
 
Two tables w/no join... figured it out. Thanks!

Ken Snell (MVP) said:
Are you joining two or more tables in the query? or does the query have more
than one table in the FROM clause and the tables are not joined in any way?

Post the SQL statement of the query and that will help us see what might be
causing the result.
Click to expand...
 
You must log in or register to reply here.

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

Split data in field on character return 0
Pass Through Query - not returning rows 1
duplicates query 2
Unexpected results when sorting multi-table query using toolbar button 5
Query Returning Multiple Results 1
query doubles up records 6
Selection query with MAX(textfield) and WHERE textfield LIKE 'mask 5
Duplicate Values in Query 1

Back
Top