How to combine two table into one in access.

[behnam]

HI everyone, i have three tables created called cycle1, cycle2 and cycle. I want to union cycle1 and cycle2 and put the results into cycle. All the tables have the same fields. I wrote the query

SELECT * FROM cycle1 UNION ALL SELECT * FROM cycle2;

but am not sure how to put the results in cycle. Thanks.

[amrut]

Select queries only display the results. To add data to table use append query. You may use this union query to append the data to your cycle table

[drexasaurus]

You could save that query and use an insert statement to move the contents of that union into the other table, or you could combine the expression, something like

INSERT INTO Cycle(col1, col2)
SELECT
col1, col2
FROM
(SELECT col1, col2 FROM cycle1
UNION ALL
SELECT col1, col2 FROM cycle2) AS UnionQry

That would work (tested a sample because Access syntax throws me off a little sometimes). You wouldn't necessarily need to reference the columns, though it's good practice. If you are going to be writing your own DML scripts and queries, it would be a good idea to start reading up on them too.