here my database tables
CASH
Id ProductId Qty
INVOICE
Id ProductId Qty
PURCHASE RETURN
Id ProductId Qty
STOCKIN
Id ProductId Qty
CREDITNOTE
Id ProductId Qty
so my stock balance should be (STOCKIN.Qty + CREDITNOTE.Qty) - (CASH.Qty + INVOICE.Qty + PURCHASE RETURN.Qty)
how to do this in access sql?
