Figure A We’ll use these two tables to demonstrate how JOINs affect your queries. Notice that the Donors table contains five records, each representing a different person.

A join combines two or more tables side by side. If you do not specify how to join the tables, you get a Cartesian product. This means that SQL combines each row from the first table with every row ...

I have a feeling that I should be able to write a single query to handle this, but I just can't think of how... Basically, I have two tables: "distributors" and "postalcodes".

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).

MS Access - Combining results from two different queries with different field names and tables 88merlin88 Nov 25, 2003 Jump to latest Follow Reply ...