In this blog post, let’s learn about the error message “220 There is no FROM clause in the query.” in Hydra and the description of the error.
Error Message
220 There is no FROM clause in the query.
Error Details
The synonym is not defined in this database. Check that the name is spelled as you intended. Check that you are using the right database. If so, the synonym was probably dropped. Possibly it was dropped automatically when the table for which it stood was dropped. To display all defined synonyms, query systables as follows:
SELECT tabname FROM systables WHERE tabtype = s