Error:- Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rubyhosp_ruby.d.docId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
with query:- SELECT d.*,dp.deptName FROM tbl_doctor d, tbl_department dp WHERE d.deptId='PSYCHIATRY CLINIC' group by d.docName ORDER BY d.docId ASC