Hello,

I need help with a select statement on my database. (I am still on L Plates
with Mysql)

My Tables

Clients                 - Holds clients infomation
Targets                 - Holds Target infomation
Clients_Targets - Holds Clients Id and Targets Id

How do I find clients that are in mutiple targets.

        Eg.     - Only Clients that are in target 1 and target 2, not
                - Clients that are in target 1 or target 2

Thank you in advance,

Simon



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to