'If all records have table1 fieldvalue1 set to 1, then update table2 fieldvalue1 to 1
I'm trying to automate the way in which a purchase order is set as delivered by using SQL.
In table Purchase_Orders I have a field called Delivered and I have a Delivered field in Purchase_Order_Items.
When all of the Items in Purchase_Order_Items associated with a particular Order_No have a Delivered value of 1, I need it to automatically update Purchase_Order.Delivered to 1.
Sorry if this is slightly confusing, I'm finding it hard to explain it simply.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|