[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
RE: [PHP] mySQL join query error
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
Re: [PHP] mySQL join query error
On Thu, 4 Apr 2002, ROBERT MCPEAK wrote: 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 You didn't tell it which table to join to. select * from tifrequest left join tifexpire using (user) where tifexpire.exp_date=2002-04-04 miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php