INNER JOIN

plz replace ur code as follows:-

SELECT F.featureid, F.[name], IIF(PF.Featureid is null, 0,1) as [bol] FROM 
features as F LEFT JOIN propertyfeatures as PF on

PF.featureid =F.featureid WHERE PF.propertyid=2