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