SELECT tblinventory.invId, tblinventory.invType, tblhouseinfo.State, tblstates.stateName FROM tblinventory INNER JOIN tblhouseinfo ON tblinventory.invId = tblhouseinfo.addInfoID INNER JOIN tblstates ON tblhouseinfo.State = tblstates.stAbrev WHERE tblinventory.mid = 1 AND tblinventory.invStatus IN (6,8,9) GROUP BY tblhouseinfo.State ORDER BY tblstates.stateName ASC

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rtkgroup.tblinventory.invId' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by