Running a query

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

Guest

I am having trouble running two tables into a query. There is no common
field among the two tables. Should I add a common field to one of the tables
in order to get the query to run?
 
Depends upon what data the two tables contain, whether the data in the two
tables are related in some way, what you want the query to do with the data,
what you want the query to tell you, etc.

You'll need to tell us a lot more about your setup. Also, please define
"trouble running two tables into a query."
 
Adding a common field after the fact may not help. The contents of the field
are more important than anything else, since the two tables would normally be
joined on the contents of one or more fields.

A query will run with two tables with no relationship links, but it will give
you one record (row) for every possible combination of the records in the two
tables. For instance, table A has 3 records, table B has 5 records (3*5 = 15)
which will return 15 rows (records). I assume this is not what you want.
 
Back
Top