Select Query to merge two identacal tables

[jpa]

I have two tables with identical structures, both linked to different sources that are updated frequently. I would like to write a query that would show all of the data from the two tables as a single unified table with the same fields as the original table.

e.g.

Table1: name, phone
Table2: name, phone

Query: name, phone (showing all records from table1 and table2)

 

[KenReay]

Hi

You need a UNION query so:

SELECT Field1, Field2,..etc FROM tbl1
UNION
SELECT Field1, Field2,..etc FROM tbl2
ORDER BY Field1

you can only make a UNION query in SQL view of the query builder, not design view Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK