I need some advice on the best way to achieve something
I need to do a SQL Query, that will return some information: Item, Company, Stock
I then need to run another SQL Query, that will have some more information, Demand, Availability. I then want this to be updated, alongside the first lot of information
I don't really want to create a temporary table or do anything within the database, I am trying to find an "offline" way of handling it - but what is the best way of doing that ?
Once that is done, I then want to be able to cycle through it, and if one value is greater than another, for an action to take place
I hope that this makes sense