Re: [PHP] MySQL Join

On Wednesday 01 January 2003 00:21, John Hinton wrote: > Stuck on this join temp > > From one table I need to > > mysql_query("CREATE TEMPORARY TABLE temp TYPE=HEAP SELECT DISTINCT > field1, field2 FROM $table"); > > both field1 and field2 have various repeating data and I need to return > only th

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