CREATE TRIGGER trigger1
    ON Orders FOR INSERT, UPDATE
    AS

    IF EXISTS(

        SELECT I.CustomerID, I.OrderDate
            FROM Orders O
                JOIN inserted I ON O.CustomerID = I.CustomerID AND I.OrderDate = O.OrderDate
                JOIN Employees E ON I.EmployeeID = E.EmployeeID
                JOIN Customers C ON I.CustomerID = C.CustomerID
            WHERE C.City = E.City
        GROUP BY I.CustomerID, I.OrderDate
        HAVING COUNT(*) > 1

    )

    BEGIN
        PRINT 'Um cliente não pode fazer mais de uma compra no mesmo dia se o fornecedor e o cliente forem da mesma cidade'
        ROLLBACK TRANSACTION
    END