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;
How Does it supports or give the result