Skip to content
Advertisement

Incorrect syntax near the keyword ‘INNER’ in sql update INNER JOIN

I tried to update some records by joining two tables. but It gives me some syntax errors.

Please help me to fix this.

Advertisement

Answer

The correct syntax in SQL Server uses FROM:

Note that I’ve also introduced table aliases so the query is easier to write and to read.

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement