Hello, I am trying to update records to make the web login = id, the password = id + last name. However when I try and execute the query I get the following error
Msg 107, Level 16, State 3, Line 1
The column prefix 'name' does not match with a table name or alias name used in the query.
I am thinking it might be bringing in the Name table but not sure. Any help would be greatly appreciated!
SET name_security.Web_login = name.id, name_security.password = dbo.gthash(name_security.id + name.last_name)
WHERE name_security.id = name.id
AND name.status = 'a' AND name.member_type in ('tac','pfc','dfc','fam','ld','pfac')
and name_security.web_login = ''