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 = 'WILLIAMSONCNTYTX' AND  [e2].Control in ('512-352-6381') )  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 = 'WILLIAMSONCNTYTX' AND  [e].Control in ('512-352-6381') )  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 » Williamson County Equipment, Texas

Browse All Featured Equipment

No equipment found