how to update in a table union all query

[learning_graccess]

I want to join two tables irrespective of duplicates so I wrote union all query . Now i want to update this into the table. I don't know how to write the query. Can you please help with this?

[mejia.j88]

can you create and update query based on your union all query, and use it to update the table?

[learning_graccess]

hi mejia, i don't know what you are asking. here i'm repeating with examples. Table1 contains a column file "number" and its values are 0,1,2,3,4,5,6,7,8,9,10). Table2 contains a column field "number" and its values are (0,1,2,3,4,5,6,7,8,9,10). Now I want to add table1 values into table2 so that in table2 output are (0,1,2,3,4,5,6,7,8,9,10,0,1,2,3,4,5,6,7,8,9,10)
I tried this but it doesn't work

insert into table2 (number)
select number from table1;

[mejia.j88]

Hi learning,
i believe what you need is either an update query or an append query.
could you post a snap shot of your two tables?
i'd like to see the fields they contain.
if you only have that field, [number], then you can use an append query to add the records from table 1 to table 2. if you have other fields, it is important to consider how the record additions will match up with the existing data.

[learning_graccess]

insert into table2 (number)
select number from table1;

The above code was correct. The only thing I had to refresh.