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.)