Subject | Help with Update using Subquery |
---|---|
Author | |
Post date | 2014-04-25T15:38:46Z |
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
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