update table1 set a = ( select a from table2 where b=1 and c=2) and b=1 where d=2
  update table1 set a = ( select a from table2 where b=1 and c=2), b=1, c=2 where d=2

  replace test-cli percent number with n% for CI