I have a query that runs perfectly on MS SQL Server, but won't on ORACLE. Please, explain wether such nested queries are allowed in oracle. Example is given below, as you see - the nested query in select statement selects a max value based on field values in select statement. if max is not available, it returns null.
select A.ID, (select max(B.SOMEFIELD) from B where B.ID=A.ID) as test
My query is more complicated, but this is simplified view.
Oracle8i Enterprise Edition Release 126.96.36.199.1 - Production
With the Partitioning option
JServer Release 188.8.131.52.1 - Production
3 (select max(e.sal) from scott.emp e
4 where deptno = d.deptno
5 ) as max_dept_sal
6 from scott.dept d;
Perhaps you should post your exact query....
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?