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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
