Combining records from 2 tables

[Guest]

Hi,

I have 2 tables, and I want to combine the records from these tables in a
query, but I don't want to match on any field. Instead, I want to just put
all records from both tables together in one query. I know I could do this
using Append queries to put records from both tables in another table, but
I'd prefer to just use a query instead of creating another table.

Is there a way to do this with a query?

Thanks,
Gordon

 

[Guest]

It is call a UNION query.