Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select in Select
You cannot use select in select with Oracle
rewrite the query
Bessenyei Zsolt <bessenyei_at_flexum.hu> wrote in article
<380AFD1B.CEB99D41_at_flexum.hu>...
> 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 - 07:06:34 CDT