Re: [PHP3] Help- What's wrong with this query???
| From: | Matthew Kendall | Date: | Fri, 02 Jun 2000 08:08:35 +0000 |
| Subject: | Re: [PHP3] Help- What's wrong with this query??? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-893@lists.php.net to get a copy of this message | ||
"gfunk007" <josh@gfunk007.com> wrote...
> select f.*, p.purchase_id
> from formbrief f, formbrief_purchase p
> where f.formbrief_id in (107,-1)
> and (p.formbrief_id=f.formbrief_id(+))
> and (p.user_id = 2622(+))
I'm not sure that the outer join operator (+) makes much sense applied to
the constant 2622 ?