In this blog post, let’s learn about the error message “295 Referenced and referencing tables have to be in the same database.” in Hydra and the description of the error.
Error Message
295 Referenced and referencing tables have to be in the same database.
Error Details
The test for a null value can be applied only to a column name (not to a subscripted character column or an expression, for example).
Review the use of these keywords in the WHERE clause and in any CASE statements.
This message does not apply to 8.21 and later 8.x database servers, which allow expressions as arguments of the IS [NOT] NULL operator.