I have two tables with a one to one relationship.
As an example:
I want to add the fields from the second table into the first table. I can add the empty fields. But I need to know, once I've added the fields, is there a way to run a query that will import that data from table2 into table1's fields? Then I can delete table2.
I know I can do this with a loop one row at a time, but I'm wondering if there is some kind of update query that will do them all at once with the query?