query technology

  • Thread starter Thread starter Gordon
  • Start date Start date
G

Gordon

I've got a question more theoretical in nature:
Can someone tell me why it is that when I set up a query
on two tables, each with 10 records, and the tables aren't
joined, I get a result with 100 records?

does the engine try to select each record uniquely and
therefore takes every unique combination of records from
the two tables?

thanks,
gordon
 
Yes, since the tables are not joined, Access is giving you
every combination of the records. It's called a Cartesian
Product.
 
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

Need a query to get rid of duplicates using two tables 1
Access Query - "Duplicate Records Selected" 5
Combine Duplicates in Query 0
Update Query for Multiple Records 4
Query to group similar number combinations? 4
unique records help please 6
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 1
Funky Query Question 1

Back
Top