query with no relations!

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

Guest

i have to create a query from tables that are not related , how is it
possible to make that happen?
 
What do you want to get back from the query? If there is no relationship
between the tables, about all you COULD get would be what's called a
"Cartesian product". That's when you get all possible "pairs" of records.

For example, if you had 6 rows in one table, and 30 rows in the second, a
"Cartesian product" would return 180 rows (6 X 30).
 
i have to create a query from tables that are not related , how is it
possible to make that happen?
Click to expand...

If you had a stack of license plates, and a stack of electric bills,
how would you decide which plate went with which bill?

Unless there is some third table (a People table in my hypothetical
example) there is no way to create a link.

Please explain what these tables contain, and what you want the
resulting query to contain.

John W. Vinson[MVP]
 
Back
Top