Apache Derby DB Error Code 42X38 – ‘SELECT *’ only allowed in EXISTS and NOT EXISTS subqueries.

Posted by AbundantCode

In this blog post, let’s learn about the error message “42X38- ‘SELECT *’ only allowed in EXISTS and NOT EXISTS subqueries.” in Apache Derby Database and the description of the error.

Error Message

42X38- ‘SELECT *’ only allowed in EXISTS and NOT EXISTS subqueries.

Error Details

‘SELECT *’ only allowed in EXISTS and NOT EXISTS subqueries.