In this blog post, let’s learn about the error message “42X04- Column ‘‘ is either not in any table in the FROM” in Apache Derby Database and the description of the error.
Error Message
42X04- Column ‘‘ is either not in any table in the FROM
Error Details
Column ‘‘ is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then ‘‘ is not a column in the target table.