Hello to all the community, we have created an application that receives orders and deliveries, 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, I have tried to create a virtual column with this ORDER[Barcode]-Sales[Product Barcode] but I pass results from all the orders, I want this to be done for the correct id and not for all the ids!
You can try
SELECT(
order[barcode],
[id] = [_thisrow].[id]
)
-
SELECT(
sales[barcode],
[id] = [_thisrow].[id]
)
3 Likes
thank you so much master, it’s what I need to go to the right id, I tried the same for the quantity, of course I pass back numbers, I could combine the expression you gave me to also get the quantity, or would I have to set the quantity column otherwise!