stephenbruceburch
Technical User
I have two tables an Inventory and a Transaction. I want to update the inventory whenever a transaction is made. but the problem I am having is that it updates the inventory for every transaction. I tried using WHERE Transaction.ID = MAX(TRANSACTION.ID) but it errored and said I couldn't use an aggregate function in a where statement. Please Help.