lienlee
08-16-2010, 05:53 AM
I have a table and it has 2 look up columns.
I want to be able to update all the columns based on 2 other columns in 2 different tables.
Append query works, however, the old data stays. I want to erase all the old data and fill the 2 columns from 2 different tables.
I've done update query for 1 to 1 table. but is it possible to use 2 tables to update 1 (its a look up table..so yea)
I want to be able to update all the columns based on 2 other columns in 2 different tables.
Append query works, however, the old data stays. I want to erase all the old data and fill the 2 columns from 2 different tables.
I've done update query for 1 to 1 table. but is it possible to use 2 tables to update 1 (its a look up table..so yea)