UPDATE tableA A1
SET A1.col1 =
(SELECT col2
FROM tableA A2, tableB B1
WHERE A2.col3 = B1.col1 AND (few MORE conditions)
AND A2.col2 = A1.col2)
WHERE
A1.col3 IN (SOME MORE conditions)
asked
What error does this query posts?? and if yes why??
16 People are following this question.
