Left join och having clause

SELECT a.province,a.city, 
   	 min(b.pricew) as lows, 
   	 max(b.pricew) as highs
    	FROM objekt AS a 
    	INNER JOIN pricecat as b ON a.id=b.shid 
    	INNER JOIN rates as c ON c.currencyF=b.currency
    	WHERE c.currencyT = @curr
    	GROUP BY a.id,a.province,a.city,c.rate,b.currency,currencyT
   	HAVING (min(b.pricew)*c.rate <= (SELECT @maxprice/rate FROM ratesnew WHERE currencyF=@curr AND currencyT = @curr))

Här får jag bara med poster om de finns representerade i tabellen "pricecat".

Jag skulle även vilja ha med posterna som inte finns med i "pricecat".
Har testat med LEFT JOIN men det fjunkar inte.
Tips?

SELECT a.province,a.city, 
   	 min(b.pricew) as lows, 
   	 max(b.pricew) as highs
    	FROM objekt AS a 
    	LEFT JOIN pricecat as b ON a.id = b.shid 
    	LEFT JOIN rates as c ON c.currencyF = b.currency
    	and c.currencyT = @curr
    	GROUP BY a.province,a.city,c.rate
   	HAVING min(b.pricew)*c.rate <= 
   (SELECT @maxprice/rate 
      FROM ratesnew 
     WHERE currencyF = @curr 
       AND currencyT = @curr) 
    or min(b.pricew) is null