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

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