this question is related to the question (SQL update logic) that i posted before.
is it possible to setMORE than one column with different values if condition is true?
set table1.ColumnA = 0 and table1.ColumnB = abc1 and table 1.ColumnC = xyz1
if table1.columnB=table2.columnX and table1.columnC = table2.columnY
set table1.ColumnA = 1 and table1.ColumnB = abc2 and table 1.ColumnC = xyz2
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.