---
title: "Problem med Join"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/191090-problem-med-join"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Zida"
published: "2013-01-23T11:41:45.000Z"
updated: "2013-01-29T14:55:04.000Z"
replies: 1
views: 535
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/191090-problem-med-join"
---

# Problem med Join

## #1 — Zida, 2013-01-23T11:41Z

Har ett litet problem med följande SQL.

```
SELECT
wp_am_quotations_products.product_id, 
wp_am_quotations_products.product_name, 
wp_am_quotations_products.product_startvalue, 
wp_am_quotations_products.product_value3, 
wp_am_quotations_products.product_value2, 
wp_am_quotations_products.product_base, 
wp_am_quotations_products.product_nb_users, 
wp_am_quotations_quote_products.product_id AS quote_product_id, 
wp_am_quotations_quote_products.nb_users 

FROM wp_am_quotations_quotes

LEFT JOIN wp_am_quotations_quote_products ON wp_am_quotations_quotes.quote_id = wp_am_quotations_quote_products.quote_id
LEFT JOIN wp_am_quotations_products ON wp_am_quotations_quote_products.product_id = wp_am_quotations_products.product_id

WHERE wp_am_quotations_quotes.quote_email = 'test@test.se'
```

Den returnerar de produkter som matchar wp_am_quotations_quote_products. Låt säga att den returnerar 2 produkter som matchar e-postadressen.

Jag vill dock att den ska returnera alla produkter som finns i wp_am_quotations_products och om produkten inte finns med i wp_am_quotations_quote_products så ska:

wp_am_quotations_quote_products.product_id AS quote_product_id, 
wp_am_quotations_quote_products.nb_users 

returnera NULL. Just nu returneras inte produkter som inte finns med matchande i wp_am_quotations_quote_products

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

## #2 — plekanec, 2013-01-29T14:55Z

Hur ska den kunna retunera null när du filtrerar på att den måste ha en epost?

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/191090-problem-med-join