Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 update from multiple tables

Author  Topic 

ppatel112
Starting Member

35 Posts

Posted - 2013-10-02 : 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.

UPDATE c
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?

regards,
parth

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-10-02 : 06:17:37
Is this what you mean?

LEFT JOIN SAMINC.dbo.ARSAP z on z.NAMEEMPL = u.user_firstname + ' ' + u.user_lastname

Is NAMEEMPLE always firstname <space> lastname?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -