create Combination 2 tabel

[iraidotel@yahoo.com]

Dear All

I have 2 tables that you want to merge.
how do it via MS Access

thank you
regards, Ira

 

[plog]

Define merge? You could APPEND data from table 2 into table 1. Or you could use a UNION query (http://www.w3schools.com/sql/sql_union.asp) which would keep the tables seperate but allow you to virtually combine them in a query.

 

[CJ_London]

use an append query to one table from the other if this is a permanent merge. Otherwise use a union query

beaten to it!

 

[iraidotel@yahoo.com]

ok, thanks all