Hi Guys,
Been a while.
Got one that I cant quite get right in my head how to do it.
I have a list of clients and the products they have purchased.
Client table:
<tbody>
</tbody>
Prod Table:
<tbody>
</tbody>
So Product table size is actually 100 products and Clients will be over 100k rows but this will be split so no issues.
What I want to do is find out what products the clients Have Not purchased.
Any ideas?
Thanks
Poc
Been a while.
Got one that I cant quite get right in my head how to do it.
I have a list of clients and the products they have purchased.
Client table:
Client Name | Products | Users | Fee | |
Mr | PROD1 | 5 | 100 | |
Mr | PROD2 | 1 | 100 | |
Mr | PROD3 | 3 | 100 | |
Excel | PROD1 | 5 | 100 |
<tbody>
</tbody>
Prod Table:
Product | Description |
Prod1 | Cats |
Prod2 | Dogs |
Prod3 | Bees |
<tbody>
</tbody>
So Product table size is actually 100 products and Clients will be over 100k rows but this will be split so no issues.
What I want to do is find out what products the clients Have Not purchased.
Any ideas?
Thanks
Poc