Re: can someone tell me what's wrong with this procedure?

Hi Sean,
how would I incorporate multiple joins?

Cheers,
Ben

On 8/14/06, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:
>
>
>
>
> On 8/14/06 8:45 AM, "ben sewell" <mosherben(at)gmail(dot)com> wrote:
>
> > Hi guys,
> > I have tried to convert an MS Access query into a stored procedure to
> run on
> > the postgres server. It's saying there is a syntax error, but I'm
> guessing
> > this is because of the multiple inner joins. Can anyone tell me the
> correct
> > syntax?
>
> From your included procedure:
> "
> .... from
> (tblproviders right join tblnewbusiness on
> (tblproviders.provider_ref=tblnewbusiness.provider_ref)) and
> (tblemployee inner join tbladvisersplit on
> (tblemployee.employee_ref=tbladvisersplit.adviser_ref)) and
> (tblnewbusiness inner join tblturnover on
> (tblnewbusiness.newbusiness_ref=tblturnover.newbusiness_ref) )and
> (tblemployee inner join tbladvisersplit on
> (tblemployee.employee_ref=tbladvisersplit.adviser_ref)) ...."
>
>
> The "from" clause has "ands" in it, which is not correct for a join.
>
> Sean
>
>