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

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:[