asked
Update query
Hi everyone trying to put together an update query based on this select query. select u.login_name, e.first_name, e.last_name, e.e_mail, u.last_login,u.status from table_user U inner join table_employee e on e.employee2user=u.objid where u.status=1 and last_login <'2010-05-22 00:01:00.000' or last_login ='1753-01-01 00:00:00.000' order by last_login Essentially I want to do is update u.status to 0 where the 2 last login critera is met. Cheers for any advice.
Try this: begin tran go UPDATE table_user SET [STATUS] = 0 WHERE [status] = 1 AND last_login ]
Whilst @Mrs_Fatherjack is right, I just wanted to add that if the join is important here, then it should also be included in the update - there may be employees in the table_user table that are not in the table_employee table - it's a subtle difference Update U.[Status] = 0 from table_user U inner join table_employee e on e.employee2user=u.objid where u.status=1 and last_login
add U SET after update and it should be good to go. You wouldn't want parens around the 2 last_login datetimes as it changes the logic
