update

[am_sarath]

Hello

i would like to update the records in two tables simulatanously.Like, i am able to select records into 2 tables using join.But, how should i do incase of update.I want to do it with only 2 tables.

Thanks in advance

 

[mbentley]

I've never actually tried this, but if your tables are linked in a relationship, you should be able to simply put both tables in your query simultaneously and set the update expressions as you would with a single table. I wouldn't try it with 2 tables that aren't linked though...not sure what would happen.