I am quite positive that I am trying the impossible, but I have the request to create a trigger that writes data to a table when a status field is updated to a certain field. This is possible, but what if the data written to the table should come from two tables? Can I use a join in the body of the trigger? I am almost certain that I cannot.
I have to store information from the second table at the same time that the trigger fires to have meaningful data stored in the new table..............
Is there an alternative way to store information from two tables into a third one in case of an event in the first table?
T. Blom
Information analyst
tbl@shimano-eu.com
I have to store information from the second table at the same time that the trigger fires to have meaningful data stored in the new table..............
Is there an alternative way to store information from two tables into a third one in case of an event in the first table?
T. Blom
Information analyst
tbl@shimano-eu.com