Re: mySQL join query error
| From: | Miguel Cruz | Date: | Thu, 04 Apr 2002 18:12:15 +0000 |
| Subject: | Re: mySQL join query error | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-91566@lists.php.net to get a copy of this message | ||
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