I create the trigger

CREATE TRIGGER InsertInOrderProducts ON OrderProducts FOR INSERT AS BEGIN IF ((SELECT inserted.quantity FROM inserted) > (SELECT Products.balance FROM Products WHERE Products.id = inserted.product_id)) BEGIN ROLLBACK TRAN PRINT 'Нет требуемого колличества товара' END END

Mistake

Could not bind composite identifier "inserted.product_id". What am I doing wrong?

    1 answer 1

     ALTER TRIGGER InsertInOrderProducts ON OrderProducts FOR INSERT AS BEGIN IF ((SELECT inserted.quantity FROM inserted) > (SELECT Products.balance FROM Products, inserted WHERE Products.id = inserted.product_id)) BEGIN ROLLBACK TRAN PRINT 'Нет требуемого колличества товара' END END