Error: SQL Error: Query Failed!\n Detail: SQL: SELECT ModelName as [groupname], count(ModelName) as [count], ModelName as [GroupNameEnglish], modelFamily as [groupparent], ( SELECT DISTINCT count(modelFamily) as [count] FROM VIEW_ELSAPI_Equipment [e2] left join equip_attributes ea on [e2].eqid = ea.eqid left join company c on [e2].Control = c.Control left join equip_note en on [e2].eqid = en.eqid WHERE ( c.MasterControl = 'DALLASFNHTX' AND [e2].Control in ('817-834-8131','972-562-9960','972-579-9999','972-937-1333','817-357-8200') ) AND ( (select count(EqId) from EQUIP_SALE_SPECIALS ss where ss.EqId = e.EqId) > 0 ) AND [e2].modelFamily=[e].modelFamily GROUP BY modelFamily ) as [groupparent_count] FROM VIEW_ELSAPI_Equipment [e] left join equip_attributes ea on [e].eqid = ea.eqid left join company c on [e].Control = c.Control left join equip_note en on [e].eqid = en.eqid WHERE ( c.MasterControl = 'DALLASFNHTX' AND [e].Control in ('817-834-8131','972-562-9960','972-579-9999','972-937-1333','817-357-8200') ) AND ( (select count(EqId) from EQUIP_SALE_SPECIALS ss where ss.EqId = e.EqId) > 0 ) GROUP BY ModelName , modelFamily ORDER BY [groupname]; SQLSTATE: 42000 code: 8120 message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column 'VIEW_ELSAPI_Equipment.eqID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Array
Browse All Featured Equipment » Landmark Equipment, Texas