Data of 2 tables in 1 query (1 Viewer)

[faaebr]

I have two tables T1 and T2. There are 12 fields in each (100%) the same. But records (data) are different. How can I have a query that merges the data of T1 & T2? When I do link, it comes T1.field1,.... and then T2.field1.... It makes a table with 24 fields! I want table that merges the records and but shows the same 12 fields. Thanks for your help.

 

[namliam]

Check out the UNION command... this will merge the tables...

Select * from table1
UNION
Select * from table2

Ps Welcome to AWF

 

[faaebr]

Namliam from Amsterdam,

PERFECTO

Thanks Danke Merci