Incorrect syntax near the keyword 'AS'. in SQL Server [duplicate]

Question

I have problem with my SQL Server query:

UPDATE latihan AS t1 ,
       (SELECT Equipment, system_status, functloc 
        FROM latihan 
        WHERE system_status='ESTO') AS t2 
SET t1.functloc = t2.functloc
WHERE t1.supereq = t2.equipment

I just want update the functloc on equipment based functloc on supereq.

The error is:

[Err] 42000 - [SQL Server]Incorrect syntax near the keyword 'AS'.
42000 - [SQL Server]Incorrect syntax near the keyword 'AS'.

Dale K · Accepted Answer · 2018-12-06 02:43:22Z

1

I think you want something like this:

update t1 set
  functloc = t2.functloc
from latihan t1
inner join (
  select Equipment, system_status, functloc
  from latihan
  where system_status='ESTO'
) t2 on t2.equipment = t1.supereq

answered Dec 6, 2018 at 2:43

Dale K

28.1k15 gold badges59 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

Incorrect syntax near the keyword 'AS'. in SQL Server [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related