Update from a Select with Multiple Joins

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

General SQL Server Forums

New to SQL Server Programming

Update from a Select with Multiple Joins

Author

Topic

StacyOW
Yak Posting Veteran

93 Posts

Posted - 2014-02-01 : 16:02:21

I am trying to do a query like this...

UPDATE    g
SET              g.GroupID = gp.GroupID, g.Contact1 = members.FirstName, g.BusPhone1 = members.BusPhone, g.HomePhone1 = members.HomePhone, g.Internet1 = members.Email 
FROM         statelst AS g INNER JOIN
                      grpcon AS gp ON g.GroupID = gp.GroupID INNER JOIN
                      members ON gp.MemberID = members.MemberID CROSS JOIN

I have my table statelst that I want to update certain columns from the values returned by a select on the grpcon table joined to the members table.

I am getting an error "Incorrect syntex near 'JOIN'. Anybody know what's wrong with this query?

Thanks,
Stacy

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-02-02 : 01:29:50

you've a CROSS JOIN in the end which is not needed


UPDATE    g
SET              g.GroupID = gp.GroupID, g.Contact1 = members.FirstName, g.BusPhone1 = members.BusPhone, g.HomePhone1 = members.HomePhone, g.Internet1 = members.Email 
FROM         statelst AS g INNER JOIN
                      grpcon AS gp ON g.GroupID = gp.GroupID INNER JOIN
                      members ON gp.MemberID = members.MemberID CROSS JOIN

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources