MS_SQL Trigger

CREATE TRIGGER InsertMailshotTable
          AFTER INSERT ON PropertyForRent
          REFERENCING NEW ROW AS  pfr
          BEGIN
                 INSERT INTO Mailshot VALUES
                 (pfr.propertyNo, pfr.street, pfr.city, pfr.postcode,pfr.type, pfr.rooms,pfr.rent
                 FROM Client c, pfr
                 WHERE c.branchNO = pfr.branchNo AND
                  (c.prefType = pfr.type AND c.maxRent < = pfr.rent)
          END;