access sql appending column

Question

I have a table that I need to Update by adding a new field.. I can alter the table and update each row . but is there a way of appending the result of a query to the table? ( I know that the result will have the same number of rows)

EDIT: So let me make it clear I have

table1 | col1,col2

I generate another single column table

table2 | col1

I want

 table3 | table1.col1,table1.col2,table2.col1

By the way table1 & table2 have no common fields so I cant join them meaningfully.

Answer 1

I think so. I haven't tested this, but what I can find it seems that you can use a SubQuery to do something along the lines of UPDATE Table1 SET Column1 = Column1 & (SELECT Column2 FROM Table2 WHERE xxxx)