Error in Selection Query <br> select a.proc_id,a.spec_id,b.name from tbl_doc_procs a RIGHT JOIN tbl_procedures b ON a.proc_id=b.id where a.doc_id='20517' group by a.proc_id order by b.name asc<br>Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ayushcms.a.spec_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by