Join the data of two tables using query

[Esmatullaharifi]

Hi to every one.
I have two tables with name of accone and the second with the name of acctwo. These two tables are same according to number of columns and also same according to data types and also same according to the column names just the data are difference and also one column (attribute) with the name of ID is same in both tables. Their is a primary key relationship (one-to-one) between these two IDs. I need a query that can combine the data of both of them and can be updated using query. I mean that data of first table and second table must become under one same column not two columns one for first table and second one for second tabel. (Don't ask me that why you use two tables with same attributes, because i need and i can't explain my need to you).

[ItsMe]

To join two tables via a query, you can create an INNER JOIN or create an OUTER JOIN using the LEFT or RIGHT keywords.
http://www.w3schools.com/sql/sql_join_left.asp

Another option may be to use a UNION.
http://www.w3schools.com/sql/sql_union.asp

It is likely you will need to use DAO to update and or append your records.

General DAO info
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

Update Method
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx