Hi all! I don't know if that was a good title, but;
I have this query (I will call it query1):
"SELECT InvID, quantity FROM Recipe WHERE MenuID = 1"
In my tables, this will give me something like Water(20), Oil(30)
Now, from this result of a SELECT query1 (i.e Water(20), Oil(30) or whatever) I want to take just Water,Oil.. (leave out the quantities) and then SELECT these InvID (water,oil..) from another table called "Inventory", but pull them with their quantity in that Inventory table.(i.e if the quantity of Water in Inventory table is 1000, pull Water (1000))
The goal is to subtract the quantities in the Inventory table with the quantities of the 1 select query (which returned 20,30...) (to get Water (1000) - Water (20) possible)
I'm making an application with VB.NET & Mysql and I'm stuck in this part. Can someone please help?