SQL Update with Inner Join Syntax

Did you get a incorrect syntax error?

Update SQL with Join

UPDATE Table1 SET Table1.Field1 = StagingTable.Field1 FROM Table1 INNER JOIN StagingTable ON Table1.Field2 = StagingTable.Field2

Include where clause to this SQL:

WHERE StagingTable.Field3 IS NOT NULL

Delete Statements

Example of DELETE TB1 Syntax  in MS Sql

FROM Table1 TB1 INNER JOIN
StagingTable ON Table1.Field2 = StagingTable.Field2

 

Example of DELETE TB1 Syntax  in  MySQL

UPDATE table1 INNER JOIN projects ON
table1. field1 = table2.field2

SET table1.field3 = table2.field4

Speak Your Mind

*