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:

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

 

[MickG]

You're welcome