All pastes #35595 Raw Edit

Unnamed

public text v1 · immutable
#35595 ·published 2006-01-03 09:23 UTC
rendered paste body
SELECT p.products_id, 
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, 
IF(s.status, s.specials_new_products_price, NULL) as final_price 
FROM products p
 LEFT JOIN specials s 
    ON s.products_id = p.products_id 
WHERE specials_new_products_price < 1000


SELECT p.products_id, 
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, 
IF(s.status, s.specials_new_products_price, NULL) as final_price 
FROM products p
 LEFT JOIN specials s 
    ON s.products_id = p.products_id 
WHERE final_price < 1000