Hi I had a search through previous posts but couldn't find an answer for this. I am creating an UPDATE trigger that writes two records (DELETED and INSERTED records) to an audit database when TABLE A is updated. However, the part that I am finding tricky is this: TABLE A is closely associated to TABLE B. (Sometimes one table will be updated; sometimes the other table will be updated; sometimes both tables will be updated). So the table in my audit database has fields pulled from both TABLE A and TABLE B. As well as referencing both the DELETED and INSERTED records from TABLE A in my trigger I want to reference both the DELETED and INSERTED records from TABLE B. Does anybody have any suggestions how I could do this with one trigger and preferably with just two records (rather than four) added to the table in my audit databse? Thanks in advance.