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
