Update table form select

[NewEra13]

How to update a table based on a select statement. Please take 5 minutes to see attached file.

sql.txt

[justsomeguy]

You can use another subquery to find records in one table that aren't in another table. You can use NOT EXISTS or NOT IN for that.

[NewEra13]

Thanks !

[NewEra13]

Hello again,

 

By the way could you help me make this update work as for i'm getting the error message:

Incorrect syntax near ')'

 

 

UPDATE dbo.Part

 

SET SupplierShortName = NationalSupplier.ShortName,

 

SupplierLongName = NationalSupplier.LongName

 

from(SELECT *

 

FROM dbo.Part

 

JOIN dbo.NationalSupplier

 

ON Part.SupplierNumber = NationalSupplier.Number

 

AND (ISNULL(Part.SupplierShortName,'') <> ISNULL(NationalSupplier.ShortName,'')

 

OR ISNULL(Part.SupplierLongName,'') <> ISNULL(NationalSupplier.LongName,''))

 

LEFT OUTER JOIN dbo.NationalPart

 

ON Part.NationalPartID = NationalPart.NationalPartID

 

WHERE Part.DWCreationEntityID = 1

 

AND NationalPart.NationalPartID is NULL)

[justsomeguy]

I'm not very familiar with UPDATE..FROM queries. Which line does it say the error is on?