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