Subject Help with Update using Subquery
Author
Is there a way to make an update query with a subquery that will update multiple records in a table (Table 1) to set a column value to 1 when the primary key values for that table exit in the subquery (SubQuery 1)?

Table 1 (Before update)
PK    Column

1        0

2        0

3        0

4        0

5        0


SubQuery 1

PK

2

3


Table 1 (After Update)

PK    Column

1        0

2        1

3        1

4        0

5        0