RE: Common code between them can be put in a stored procedure and the triggers can both call that procedure for whatever they have in common, and do separate work...

thanks a lot.

However i want to be able to view fields from both derived table, i can only see t 3 fields selected from the first query and the one...