I have 3 tables.
Table1 : Items - Itemcode - Description - Brand -
Table 2 : Customers : Customercode - CustomerName - Salesrep
Table 3 :Transactions : Date - Reference-CustomerCode-Salesrep-Itemcode - Qty-Value-
my question is as follows:
I need to know what customers did NOT buy from that item- (i.e. there is no record in Transactions that has this customer and this item)
The second question will be how can them all ...
i.e. each customer what are the items that they did not buy (no transaction)