[SOLVED] 3 Table Comparison

[alanChurley]

ok, i have the following sql statement;

 

Code:

SELECT

data.mobilenumber,

data.firstname,

bookedparties.partydate,

bookedparties.partyguests,

clubs.brand

FROM

data,

bookedparties,

clubs

WHERE

data.contactid = bookedparties.contactid

AND bookedparties.club = clubs.club

AND bookedparties.partydate = '2009-03-30'

AND bookedparties.canceled = '0'

AND data.gender = 'F';

 

When i run the statement, it only selects those that match records that match one of the clubs.club

 

I really don't know where to start or if I'm being really stupid - any help is greatly appreciated

MySQL 5.0.45 via TCP/IP

[corbin]

"AND bookedparties.club = clubs.club "

 

 

Errr yeah...  That's what you're telling it to do?  Perhaps you want a LEFT JOIN?

[alanChurley]

Thank you