I have two tables in a database. One of them contains the received stock and the other the sold stock. So the current stock is received stock-sold stock. But how do I put this into an SQL statment. What I would like to do basically, is subtract the sold stock table from the received stock table. I tried:

SQLQuery = "select stock.* from stock inner join sold on not stock.serialnr=sold.serialnr"

But it doesnt work. Inner join does the opposite: it adds the databases. I was wondering if there is a way to invert this operation.

I am assuming the column names Received and Units, change those columns to fit your tables.