ORA-00913: too many values

Cause: The SQL statement requires two sets of values equal in number. This error occurs when the second set contains more items than the first set. For example, the subquery in a WHERE or HAVING clause may return too many columns, or a VALUES or SELECT clause may return more columns than are listed in the INSERT.

Action: Check the number of items in each set and change the SQL statement to make them equal.

SQL> select e.ename, e.job, e.sal
  2  from emp e
  3  where e.deptno in (select d.deptno, d.dname
  4                     from dept d
  5                    );
where e.deptno in (select d.deptno, d.dname
                   *
ERROR at line 3:
ORA-00913: too many values


SQL>