I have table users and field 'import' which is an 'int', i need to update its value to 1 when:
FROM dbo.Partiescont a
Inner join users b on b.userid = a.userid
INNER JOIN users z ON z.userid = a.partcontid
WHERE z.EmployerId = 15304
The above statement returns the 'id' of all records from 'users' table. 'userid' is the ID field of such table.
So something like:
set import = 1 where
and then use the results from the selection above to update those records ... how would the syntax be ?