MySQL Error: Invalid SQL: SELECT DISTINCT personnel.* FROM personnel LEFT JOIN jobXref ON personnel.ID=jobXref.persID LEFT JOIN jobTitles ON jobXref.titleID=jobTitles.ID LEFT JOIN jobGroups ON jobTitles.grpID=jobGroups.ID LEFT JOIN ipbDivs ON jobGroups.divID=ipbDivs.ID WHERE jobGroups.divID=1 ORDER BY jobGroups.seq, jobTitles.seq;
Database error: 3065 (Expression #1 of ORDER BY clause is not in SELECT list, references column 'fishdive.jobGroups.seq' which is not in SELECT list; this is incompatible with DISTINCT)
Please contact us [ken@kenvective.com] and specify the exact error message.
Session halted.