I have set up a query in Base to my MySQL 5.7 backend,
SELECT CONCAT(COALESCE(PERSONNEL.FIRSTNAME, ''), ' ', COALESCE(PERSONNEL.LASTNAME, '')) PERSONNEL, authtypes.AUTHNAME AUTHORIZATION, authorizations.DATE DATE
FROM PERSONNEL JOIN AUTHORIZATIONS ON
AUTHORIZATIONS.PERSONNEL = PERSONNEL.ID JOIN AUTHTYPES ON
AUTHTYPES.ID = AUTHORIZATIONS.AUTHTYPE
ORDER BY PERSONNEL.ID
When I try to run the Query, I get
Syntax error in SQL statement
And when I Tools>SQL and run it that way, it returns what I expect. This seems to be a glitch. Anyone who can explain this behavior so I can avoid it in the future?