Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select in Select
You could set it up as a join -- oracle doesn't support select in select:
select field1,field2 from table1,table2 where field3=1
Bessenyei Zsolt <bessenyei_at_flexum.hu> wrote in message
news: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:15:11 CDT