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).

 

[plog]

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...

Then this should all be in one table, not 2. You wouldn't have a FemaleTable and a MaleTable--you would have one table and then add a Gender field to that one table to distinguish if a record was for a male or a female.

You are doing the same thing. You need to merge the data in these 2 tables into 1 table.

 

[jdraw]

What is this suppose to mean???
(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).


Try.
If you are working from specifications, or requirements or business facts or whatever something must be causing/influencing you to do this. The design you are suggesting is strange to say the least--there must be some rationale for using it. If not, then change your design to meet your requirements using established practices. (normalization).

 

[jnolfo]

I agree with jdraw on this. Try and explain why.

However, one thing you could do is make to make a new table with on of them and then do an append query on the second table and map the fields accordingly.

 

[RainLover]

I agree with jdraw on this. Try and explain why.

However, one thing you could do is make to make a new table with on of them and then do an append query on the second table and map the fields accordingly.

This would in my opinion be the best plan, based upon the information you have given. That is unless you have a problem with your Primary key and its joins.