In this blog post, let’s learn about the error message “42Y70- The user specified an illegal join order. This could be caus” in Apache Derby Database and the description of the error.
Error Message
42Y70- The user specified an illegal join order. This could be caus
Error Details
The user specified an illegal join order. This could be caused by a join column from an inner table being passed as a parameter to an external virtual table.