subject:"\[PHP\-DB\] left joins and mysql"

RE: [PHP-DB] left joins and mysql

2002-01-31 Thread Rick Emery

ht_id && p.player_status='captain' ORDER by t.flight_id -Original Message- From: tom hilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 31, 2002 8:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] left joins and mysql Hi, I am trying to do a left join on a "master" ta

[PHP-DB] left joins and mysql

2002-01-31 Thread tom hilton

Hi, I am trying to do a left join on a "master" table, but I don't want to pull all the records from this table. Can anyone tell me the syntax for using a WHERE or equivalent on the master table before left joining the slave table? Is this possible, or do I have to pull all the records from the