change to: SELECT * FROM tifrequest LEFT JOIN USING(user) WHERE tifexpire.exp_date >="2002-04-04"
It helps if you provide the error message. Also, this would have been found when you entered it directly into the mysql command line prompt. -----Original Message----- From: ROBERT MCPEAK [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 11:45 AM To: [EMAIL PROTECTED] Subject: [PHP] mySQL join query error I get an error with the follow query. There is a field "user" in both tables, tifrequest & tifexpire. Can anybody see what's wrong with it? Thanks. SELECT * FROM tifrequest LEFT JOIN USING(user) WHERE tifexpire.exp_date >=2002-04-04 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
