If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Does Any DBMS supoorts Query like
Select ColName , (Select ColName From TableName ) from AnotherTableName

Where the query in selectList can give the multiple Result .

Infact In Oracle Reference Guide I have found the following Example
SELECT department_name, CURSOR(SELECT salary, commission_pct
FROM employees e
WHERE e.department_id = d.department_id)
FROM departments d;

Originally posted by stecal Oracle does not do "Select ColName , (Select ColName From TableName ) from AnotherTableName"

Oh yes, it does. At least from 8.1.7 and above, not sure about 8.1.6. The only catch is that a subquery in a select list must return only one value - that is select mus result in a single row-single coulumn resultset.

It works if you use the correct syntax. When a subselect in a select list returns more than one column or more than one row (or both), you must use so called "cursor expression", which is basicaly the same as REFCURSOR in PL/SQL.