1
Answer

sql sercer in keywords

Ganesh M

Ganesh M

10y
616
1
Hi,
i my query is 
select pf.PropertyId,count(pf.FeatureId) as Count from SaleProperties sp left join PropertyFeatures pf on sp.PropertyId=pf.PropertyId left join Features f on f.FeatureId=pf.FeatureId where f.FeatureType in('Parking','Rural/secluded','Waterfront') group by pf.PropertyId 


it give the result  that has featuretype in either 'Parking','Rural/secluded','Waterfront' .i want result that the property has has all three featuretype 
how to query it
Answers (1)