Posted - 10/02/2013 : 01:19:11
| Hi Folks,
i am using 4 tables company, users, ARSAP, ARCUS to update a column in company table.
the tsql i am using is below.
SET c.comp_primaryuserid = u.user_userid
FROM Company c, Users u
LEFT JOIN SAMINC.dbo.ARSAP z on z.NAMEEMPL = 'u.user_firstname u.user_lastname'
LEFT JOIN SAMINC.dbo.ARCUS y on z.CODESLSP = y.CODESLSP1 WHERE y.IDCUST = c.comp_companyid
the validation "LEFT JOIN SAMINC.dbo.ARSAP z on z.NAMEEMPL = 'u.user_firstname u.user_lastname'" is not working though the sql is correct, there is no relation between ARSAP table and users table.
I just want to match the firstname lastname from column NAMEEMPL (table ARSAP) to users table user_firstname user_lastname.
i am stuck at this point and i cant update c.comp_primaryuserid = u.user_userid to fix this up.
any ideas to help?