Re: ORA-00905: missing keyword

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 11 Feb 2011 19:05:54 +0530
Message-ID: <AANLkTinExb7F1jL7F5OuUqmnTgUSNbzvpnJr1+y2sQeZ_at_mail.gmail.com>

is this ansi sql...
'join' only is sufficient or 'left join' is required in last two joins just before the where clause..thanks..subodh

On 11 February 2011 17:58, jose soares <jose.soares_at_sferacarta.com> wrote:

> Hi all,
>
> What's wrong with this query?
>
> SELECT DISTINCT count(*) FROM scadenziario
> left join operatore ON scadenziario.id_veterinario_programmato=
> operatore.id
> left join anagrafica ON operatore.id_anagrafica=anagrafica.id
> join unita_aziendale ON scadenziario.id_unita_aziendale =
> unita_aziendale.id
> join anagrafica as aua ON aua.id = unita_aziendale.id_anagrafica
> WHERE id_piano= 23
>
> it gives me this error:
> cx_Oracle.DatabaseError: ORA-00905: missing keyword
>
>
> I tried it in PostgreSQL and it works.
>
>
> Thanks for any help.
>
> j
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 11 2011 - 07:35:54 CST