Re: Help - Selecting from many to many table.

2001-07-08 Thread Rolf Hopkins
"Mysql" <[EMAIL PROTECTED]> Sent: Sunday, July 08, 2001 2:08 Subject: Help - Selecting from many to many table. > Hello, > > I am new to SQL and just learning. > > I have a table of clients and a table of targets. I have a clients_targets > table holding the ke

Help - Selecting from many to many table.

2001-07-07 Thread Simon
Hello, I am new to SQL and just learning. I have a table of clients and a table of targets. I have a clients_targets table holding the keys for relating. I am having troble trying to select clients that are in more than one target. Eg. Select c.First_Name, ... From clients as c, clients_targ