I would like to try active record and its update feature.
Here’s my query:
UPDATE bau, test
SET basisname = test.text
WHERE bau.process_1_ID = test.p_1_ID
AND bau.process_2_ID = test.p_2_ID
AND bau.process_3_ID = test.p_3_ID
AND bau.ee_ID = 0;
Please someone tell me how to put condition and other parametres