In this blog post, let’s learn about the error message “324 Ambiguous column column-name.” in Hydra and the description of the error.
Error Message
324 Ambiguous column column-name.
Error Details
The column name appears in more than one of the tables that are listed in the FROM clause of this query. The database server needs to know which columns to use. Revise the statement so that this name is prefixed by the name of its table (table-name.column) wherever it appears in the query. If the statement becomes unwieldy, give the table a shorter alias name in the FROM clause (see the discussion of error -316 for an example).