SELECT in a [select_list]

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 ????

Thanks.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 26 1999 - 05:58:25 CDT