Re: ORA-00933: SQL command not properly ended

From: Norman Dunbar <>
Date: Fri, 04 Jan 2013 16:34:09 +0000
Message-ID: <>

Afternoon Jose,

On 04/01/13 16:07, Jose Soares wrote:
> Hi all,
> I have a query that succeed in postgres but it fails in oracle and I
> don't know why?

> select v.articolo,fs.descrizione as
> fontes,s.articolo,s.importo_min,s.importo_max from norma as s join norma
> as v on = v.id_norma_sanzionatoria join fonte as fv on
> join fonte as fs on;

Removes the "as" when aliasing your table names. It is allowed when aliasing column names, but not tables.

You need something like:

select 	v.articolo,
	fs.descrizione as fontes,
from 	norma s
join 	norma v on = v.id_norma_sanzionatoria
join 	fonte fv on v.id_fonte =
join 	fonte fs on s.id_fonte =;


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
Received on Fri Jan 04 2013 - 17:34:09 CET

Original text of this message