Update with inner join?

Question

I have two databases:

DB1 and DB2

How to do something like:

update myServer.DB1.dbo.hotels.Name = myServer.DB2.dbo.hotels.Name join myServer.DB2.dbo.hotels on myServer.DB2.dbo.hotels.Code= myServer.DB1.dbo.hotels.Code where myServer.DB2.dbo.hotels.CountryCoe != myServer.DB1.dbo.hotels.CountryCode

Quassnoi · Accepted Answer · 2010-05-17 13:51:18Z

11

UPDATE h1 SET h1.name = h2.name FROM myServer.DB1.dbo.hotels h1 JOIN myServer.DB2.dbo.hotels h2 ON h2.Code = h1.Code WHERE h1.CountryCode <> h2.CountryCode

answered May 17, 2010 at 13:51

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Philip Kelley Over a year ago

Picked this over SQLMenace' identicial version because ON clause is on it's own line -- necessary, when you have AND clauses within your ONs...

SQLMenace · Accepted Answer · 2010-05-17 13:52:04Z

example

update h1 set h1.Name = h2.Name from DB1.dbo.hotels.Name h1 join DB2.dbo.hotels h2 on h1.Code= h2.Code where h2.CountryCoe != h1.CountryCode

Adriano Carneiro · Accepted Answer · 2011-09-26 17:03:51Z

This should do the trick for you. You were missing the SET and FROM clauses.

UPDATE DB1 SET DB1.Name = DB2.Name FROM DB1.dbo.hotels DB1 INNER JOIN DB2.dbo.hotels DB2 ON DB2.Code = DB1.Code WHERE DB2.CountryCoe != DB1.CountryCode

Collectives™ on Stack Overflow

Update with inner join?

3 Answers 3

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Linked

Related