What will be the MS Access SQL to mix both of these tables? Table1 has column A, B, and C. Table2 includes a, D, and E. I would like the ultimate result to become a,W,D,Deb,At the where (join) Table1 A equals Table2 A.

Union/UnionAll informs me the posts don't match. Place into provides me with an identical error. Thanks ahead of time for just about any help. (Sorry this really is most likely a noob question)

UNION is perfect for mixing data with equal posts, the thing you need is really a JOIN

Choose t1.A,B,C,D,E FROM table1 t1 JOIN table2 t2 ON t1.A = t2.A

I simply examined this in MS Access 2003 also it labored:

SELECT t1.A, t1.B, t1.C, t2.D, t2.E
INTO Table3
FROM Table1 t1
LEFT JOIN Table2 t2
ON t1.A = t2.A

I acquired all data from table1 and table2 during my new table.

choose a.A,a.B,a.C,b.D,b.E from Table1 a, Table2 b in which a.A==b.B

This labored for me personally

SELECT Table1.*, Table2.*
FROM Table1 LEFT JOIN Table2 ON Table1.A=Table2.A;