Many thanks for the replies, i have amended accordingly but the Field that doesn't have any records assigned to it still not appearing as NULL or 0

SELECTEV.Value AS 'Ind Type Name', COUNT(EV.ExtraValueID) AS 'Count'

FROMExtraContact EC LEFT JOIN ExtraValue EV ON EV.ExtraValueID = EC.ExtraValueID

LEFT JOIN ExtraField EF ON EV.ExtraFieldID = EF.ExtraFieldID

GROUP BYEV.ExtraFieldID, EV.Value, EV.ExtraValueID

HAVINGEV.ExtraValueID IN (24699,24701,24706,24707,24710,24713,24734,24779,24740,64346,64350,24760)

OR EV.ExtraValueID IS NULL

ORDER BYEV.Value

The ExtraContact tbl contains only two columns ExtraContactID and ExtraValueID which is FK to the ExtraValue tbl which contains the Value (name of the Industry Type)