SQLCODE -412
SQL0412 Subselect returns more than one column
- IBM message text
- Subselect with more than one result column not valid.
- SQLCODE
- -412
- SQLSTATE
- 42823
Most common cause
A subquery used in a comparison or in IN with a single expression returns more than one column.
Other causes
- A SELECT * inside a subquery.
How to fix it
Select a single column in the subquery, or rewrite with EXISTS or a join.
Related errors
Text and codes from IBM documentation for 7.6. Checked on .