fork download 
  1. UPDATE TASK tas2
  2. SET TARGET_WORK_QTY = (SELECT REMAIN_WORK_QTY FROM TASK tas1
  3.                               WHERE TASK_ID.tas1 = TASK_ID.tas2
  4.                               AND PROJ_ID = 884)
Success #stdin #stdout #stderr 0s 18088KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
stderr 
Error: near line 1: near "tas2": syntax error
https://ideone.com/ocLC09
language:
SQLite (sqlite 3.27.2)
created:
8 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!