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 


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to