carls
4Penny.net
Points: 3300

7/17/2018 1:36:47 PM

Working with 1 or all items

* This article, and all our great SQL for Beginners documentation, Is available on the SQL for Beginners menu
I had a request for a query that would update either 1 item or all items in the IV00102 table, using quantities from the SOP10200 table.  
 
4Penny.net
Version: Unknown or N/A
Section: SQL for Beginners
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3