SELECT im.itemid,im.typename,sm.name FROM 
f_itemmaster im 
INNER JOIN f_subcategorymaster sm 
ON im.subcategoryid=sm.subcategoryid
WHERE im.isactive=1 AND sm.subcategoryid<>'LSHHI15' 
AND sm.depttype NOT IN ('Package','NonPath')
AND sm.name NOT IN ('MRI','X-RAY DIGITAL') AND sm.active=1