At the bottom of the SQL-query pages is a button 'Change' to help with an ORDER BY part of the query.
When the SELECT contains a JOIN part,
and fields from the joined table are selected for the ordering,
these names are entered into the query without table-name-qualification.
This results in a general SQL error during execution.
Manually adding this table name qualification in the available textfield is easy, but a warning is lacking.