> 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.
