I have two tables. Table_a has rows that are uniquely identified by an ECSOID value. there is a bit field in that table called "Arrest". That bit field needs to be set to 1 if the ecsoid for that row exists in another table (table_b). My assumption wast that i would be doing an innerjoin between the two tables on the existence of the ECSOID in table_b, similar to:Update aSet a.arrest = 1From Table_bInner Join table_awhere a.ecsoid in(select ECSOID in Tables.dbo.Table_b)
obviously, the above isn't working or i would not be here.
Set bit field in one table according to existence
Posted - 2012-08-29 : 12:06:34
