<P> Set the value of column C1 in table T1 to 2, only if the value of column C2 is found in the sublist of values in column C3 in table T2 having the column C4 equal to 0 . </P> <P> One may also update multiple columns in a single update statement: </P> <P> Complex conditions and JOINs are also possible: </P> <P> Some databases allow the non-standard use of the FROM clause: </P>

How to update values into table in sql