Re: SELECT in a [select_list]

Try this:

select d.attr, y.maximun from d, (select max(b) as maximum from c) y;

Hope this helps and will adress your problem. Bye, Jan

Doktor wrote:

> It's possible but only by using embedded SQL.
>
> abeba_at_my-deja.com wrote:
> >
> > Using Oracle8, I want to submit this query :
> >
> > SELECT a , (SELECT MAX(b) FROM c)
> > FROM d
> >
> > but I keep having the same message : (ORA-00936 missing expression)
> >
> > Is it possible to have a query in a [SELECT_LIST]
> > or are there any other ways to do the same thing ????

--

Jan Nowitzky o Friedrich-Schiller-Universität o Institut für Informatik o

D-07740 Jena o Tel. +49/3641/9-46363 o
E-Mail nowitzky_at_informatik.uni-jena.de | jan.nowitzky_at_sap-ag.de
---------------------------------------------------------------------------