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