Oracle Message ORA-02324 - more than one column in the SELECT list of THE subquery

ERRORmore than one column in the SELECT list of THE subquery
CAUSEMore than one column was selected in the THE subquery.
ACTIONSpecify only one column in the SELECT list of the THE subquery and retry the operation.