How To Code This Trigger

[Chris Thompson]

Hi All,

I'm wondering if someone can help me with coding a trigger based on the following code ? I'm a bit rusty with Triggers and this one is especially complicated for me. I've tried to simplify the code a bit with some generic terms. The basic idea of what I want to do is>:

IF (SELECT target_field1 FROM Database1.Table WHERE verificationfield1 = 'data') <>
(SELECT target_field2 FROM Database2.Table WHERE verificationfield2 = 'data')
THEN
UPDATE Database1.Table
SET target_field1 = (SELECT target_field2 FROM Database2.Table WHERE verificationfield2 = 'data')
WHERE verificationfield1 = 'data'
END IF;

I'm looking to fire this trigger AFTER an UPDATE to the Database2.Table field. Any help would be tremendously appreciated.