SELECT * FROM tblinvtype WHERE tblinvtype.mid = 1 AND tblinvtype.typeId <> 67 AND tblinvtype.type_status = 1 ORDER BY tblinvtype.typeName<BR><BR>