AnsweredAssumed Answered

Found contacts and omit them

Question asked by techccaq on Nov 17, 2009
Latest reply on Nov 18, 2009 by philmodjunk

Title

Found contacts and omit them

Post

Hello,

 

 

I have 100 contacts.  Each contact have some activities associated to him.

 

I would like to know how to find, in the 100 contacts, which person does not have a particular activities.

 

My table name for customers is customers.  Another table is called activities.  I also have another table called order_lines.

 

The order_lines table contains all the activities that all customers have.

 

 

Thanks for you help

 

 

Outcomes