SQL Inner join 2 tables with multiple column conditions and update

sql sql-update inner-join
marilyn picture marilyn · Jul 1, 2010 · Viewed 109.8k times · Source

I am using this script, trying to join 2 tables with 3 conditions and update T1: 

Update T1 set T1.Inci = T2.Inci 
ON T1.Brands = T2.Brands 
AND T1.Category= T2.Category
AND T1.Date = T2.Date

but I encounter:

Incorrect syntax near the keyword 'ON'.

Can't figure it out why.

Answer

Robin Day picture Robin Day · Jul 1, 2010 
UPDATE
    T1
SET
    T1.Inci = T2.Inci 
FROM
    T1
INNER JOIN
    T2
ON
    T1.Brands = T2.Brands
AND
    T1.Category= T2.Category
AND
    T1.Date = T2.Date

Related questions

UPDATE statement with multiple joins in PostgreSQL

I'm trying to update a table called incode_warrants and set the warn_docket_no to the viol_docket_no from the incode_violations table. I have the following SQL query in Postgres 9.3, but when it fires I get the …

Read More
Postgres update with an inner join across 2 tables?

I have 3 tables in my local Postgres database: [myschema].[animals] -------------------- animal_id animal_attrib_type_id (foreign key to [myschema].[animal_attrib_types]) animal_attrib_value_id (foreign key to [myschema].[animal_attrib_values]) [myschema].[animal_attrib_types] -------------------------------- …

Read More
SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the account number, so that I am only working with account numbers. I created a view linking the …

Read More