Hello to all the community, we have created an application that receives orders and sales, we have 2 tables, 1 table is order(barcode,quantity,id) and we have a second table sales(barcode,quantity,id).I want to create a comparison between these two tables and show me a list of products that have not been sold, and the remaining quantity.For the first problem, I found the solution with select,(thank you @TeeSee1 )
SELECT(
order[barcode],
[id] = [_thisrow].[id]
)
-
SELECT(
sales[barcode],
[id] = [_thisrow].[id]
)
but I can’t find anything similar to show me exactly the remaining quantity!When I use something similar and for the quantity with select I just get a number and not the product and the exact number with the remaining products!
please help @Steve , @TeeSee1 ,@Joseph_Seddik