如何使触发器与两个源表一起工作？

CREATE TRIGGER trg_UpdateSummary
ON DATABASE
FOR INSERT
AS
BEGIN
    SET NOCOUNT ON;

    IF EXISTS (SELECT * FROM INSERTED WHERE TABLE_NAME = 'TableA')
    BEGIN
        -- 更新SummaryTable基于TableA的INSERT操作
        UPDATE SummaryTable
        SET Column1 = (SELECT NewValue FROM INSERTED WHERE TABLE_NAME = 'TableA'),
            Column2 = (SELECT AnotherValue FROM INSERTED WHERE TABLE_NAME = 'TableA')
        WHERE KeyColumn IN (SELECT KeyColumn FROM INSERTED WHERE TABLE_NAME = 'TableA');
    END

    IF EXISTS (SELECT * FROM INSERTED WHERE TABLE_NAME = 'TableB')
    BEGIN
        -- 更新SummaryTable基于TableB的INSERT操作
        UPDATE SummaryTable
        SET Column1 = (SELECT NewValue FROM INSERTED WHERE TABLE_NAME = 'TableB'),
            Column2 = (SELECT AnotherValue FROM INSERTED WHERE TABLE_NAME = **'TableB'**)
        WHERE KeyColumn IN (SELECT KeyColumn FROM INSERTED WHERE TABLE_NAME = 'TableB');
    END
END;