Hello. Need a little help building your SQL query?

Question

SQL

Not strong in the SQL language, and because of this, all the work hangs, since the results of this query must be displayed in c ++ in DBGRID. There is a warehouse database. I need to write an SQL query or SQL function (I don't know how to solve this problem) that will fill in the "inventory" table (shows what goods and how much is stored in the warehouse at the moment). db ("goods", "sales", "delivery", "inventionary"). It is necessary for the query or function to count the amount(amounts) of goods in stock at the given moment. yes, if we make a record in the "sales" table, then the amounts value decreases, and if in the "deliveries" table, on the contrary, the value of amounts in the inventory table increases. That is, so that this table is updated if we enter data into others. Is it feasible in principle?

Answer 1

Yes, it's doable.