Select in Select

Hello,

When I run this query:

select field1, (select field2 from table2 where field3=1) from table1

this error message appears:

ORA-00936: missing expression

Exactly the same query runs well on Sybase SQL Anywhere and MSSQL.

How can I use a SELECT as a field ?

Zsolt Bessenyei Received on Mon Oct 18 1999 - 05:57:31 CDT