Query to combine tables

How can I make a Query that combines tables, so that if table1 has records
"apples", "pears" and table2 has records "apples", "cherries", the query
result will be "apples", "pears", "cherries"?

Thanks.

Alex

Try an SQL union query:

SELECT Field FROM table1
UNION SELECT Field FROM table2;

Alex Chun wrote:

Quote:

>How can I make a Query that combines tables, so that if table1 has records
>"apples", "pears" and table2 has records "apples", "cherries", the query
>result will be "apples", "pears", "cherries"?
>
>Thanks.
>
>Alex

--
Message posted via http://www.accessmonster.com

Query to combine tables

re: Query to combine tables

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about