[PHP] mySQL join query error

2002-04-04 Thread ROBERT MCPEAK
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

RE: [PHP] mySQL join query error

2002-04-04 Thread Rick Emery
:[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

Re: [PHP] mySQL join query error

2002-04-04 Thread Miguel Cruz
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