Hi, I wish to combine three tables into one. Please help Thanks! Boss
A Alex Dybenko Aug 18, 2008 #2 Hi, you can either use append query and put data into 1 table, or use UNION query for get data from all 3 tables like: select field1 from table1 union select field1 from table2 union select field1 from table3 -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
Hi, you can either use append query and put data into 1 table, or use UNION query for get data from all 3 tables like: select field1 from table1 union select field1 from table2 union select field1 from table3 -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com
