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;