What have the clients NOT purchased?

[pocquet]

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client Name[/TD]
[TD]Products[/TD]
[TD]Users[/TD]
[TD]Fee[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr[/TD]
[TD]PROD1[/TD]
[TD]5[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr[/TD]
[TD]PROD2[/TD]
[TD]1[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mr[/TD]
[TD]PROD3[/TD]
[TD]3[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Excel[/TD]
[TD]PROD1[/TD]
[TD]5[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Prod Table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Description[/TD]
[/TR]
[TR]
[TD]Prod1[/TD]
[TD]Cats[/TD]
[/TR]
[TR]
[TD]Prod2[/TD]
[TD]Dogs[/TD]
[/TR]
[TR]
[TD]Prod3[/TD]
[TD]Bees[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[MickG]

You're welcome