conditional update

[hklein]

Hello, I have a table1 and table2 linked to eachother with an ID fiels. I would like to make an update on table1. if the value of table1.ID exist in the table2, then I would like the table1.field1 to have the value "yes". Could anybody know, how tu build up a query like this? Thank you

[alansidman]

Here is a quick tutorial on update queries

http://www.youtube.com/watch?v=--PVVLIcbjE

Join your two tables on the ID. Make the join a Left Join with Table1 your first selection.

In your criteria for the ID in table 2, set it to Not Null

Make sure to back up your tables before you begin in case you make a mistake. Update Queries cannot be unwound.