Social Sector


SELECT tbl_sector.sectorname, tbl_sector.sectorid FROM tbl_sector INNER JOIN tbl_macrosector ON tbl_macrosector.msectid = tbl_sector.msectorid INNER JOIN tbl_mdp ON tbl_sector.sectorid = tbl_mdp.subsector and tbl_sector.msectorid='1' group by tbl_sector.sectorname order by tbl_sector.sectorname - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's0417pnd_pndweb.tbl_sector.sectorid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by