On Sunday 10 November 2002 08:51 am, Hannu Krosing wrote:
> snpe kirjutas L, 09.11.2002 kell 22:51:
> > Hello,
> > I work with JDeveloper and PostgreSQL JDBC and I have one problem.
> > I get error :
> > sub-SELECT in FORM must have an alias
> > I can't change SQL command, but it is internal JDeveloper command
>
> You could set up query logging in the backend and see what the offending
> query is. It may still be something you did (a missing or extra
> something somewhere).
>
query is like this :
select * from (select * from tab) where 1=2
This is work with Oracle,DB2,SQL Server
Postgresql request alias in sub-select in from clause
regards
Haris Peco