UPDATE test1 ; SET field1 = 10 ; FROM test1 ; WHERE field3 = 'TEST' AND field2 = '123456'; AND field2 IN (SELECT field2 FROM test2 ; WHERE field4 = '789102' and field5 = .f. AND field6 = .f.)