query technology

[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

 

[Les]

Yes, since the tables are not joined, Access is giving you
every combination of the records. It's called a Cartesian
Product.