Oracle does not do "Select ColName , (Select ColName From TableName ) from AnotherTableName"
SQL> select dname, (select job, sal from bonus) from dept;
select dname, (select job, sal from bonus) from dept
*
ERROR at line 1:
ORA-00913: too many values




Reply With Quote