I have an as yet, very simple database consisting one table of all items of stock. I have CSV files, jobs, which contain a subset of those items, periodically, to replenish stock a CSV file is generated again a subset of the items of stock. I want to know what direction my thinking needs to be so that I can subtract or add item by item CSV file contents from/to the database of all items. Basically put or take a list into or out of stock items.
HELP!!!
Please Tynus