---
title: "Left join och having clause"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/140765-left-join-och-having-clause"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Jesper T"
published: "2006-01-13T01:26:37.000Z"
updated: "2006-01-13T08:49:32.000Z"
replies: 1
views: 205
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/140765-left-join-och-having-clause"
---

# Left join och having clause

## #1 — Jesper T, 2006-01-13T01:26Z

```
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?

Permalänk: https://www.webforum.nu/p/140765

## #2 — LarsG, 2006-01-13T08:49Z

```
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
```

Permalänk: https://www.webforum.nu/p/1745616

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/140765-left-join-och-having-clause