CODEWITHSUNDEEP
mysql
Anju
Anju

Reputation: 502

Issues in Mysql query

I'm trying since long in one query by checking same fields. My query is like this 

SELECT DISTINCT products.products_id,products_description.products_title, products_sizes.size_id, products_sizes.size_title,products_sku.sku     
FROM products_description
LEFT JOIN products ON products_description.products_id = products.products_id
LEFT JOIN products_sizes ON products_description.products_id = products_sizes.products_id
LEFT JOIN product_stock_history ON product_stock_history.products_id = products.products_id
LEFT JOIN products_sku ON products_sku.size_id = products_sizes.size_id
WHERE products.enable_stock_management = '1'
AND products.products_id != '-11'

this retrieves result like below

enter image description here

But i would like to retrieve the details like below by checking whether sizeid is different then only display, else retrieve the first record

enter image description here

Is this possible to achieve?

Upvotes: 0

Views: 45

Answers (2)

Daniel Paiva
Daniel Paiva

Reputation: 121

I think this will work as you expects

SELECT DISTINCT products.products_id,
                products_description.products_title,
                products_sizes.size_id,
                products_sizes.size_title,
                products_sku.sku
FROM products_description
LEFT JOIN products ON products_description.products_id = products.products_id
LEFT JOIN products_sizes ON products_description.products_id = products_sizes.products_id
LEFT JOIN product_stock_history ON product_stock_history.products_id = products.products_id
LEFT JOIN products_sku ON products_sku.size_id = products_sizes.size_id
WHERE products.enable_stock_management = '1'
  AND products.products_id != '-11'
GROUP BY size_id,
         size_title

Upvotes: 1

Sunil Sinare
Sunil Sinare

Reputation: 21

    SELECT DISTINCT products.products_id,products_description.products_title, products_sizes.size_id, products_sizes.size_title,products_sku.sku     
FROM products_description
LEFT JOIN products ON products_description.products_id = products.products_id
LEFT JOIN products_sizes ON products_description.products_id = products_sizes.products_id
LEFT JOIN product_stock_history ON product_stock_history.products_id = products.products_id
LEFT JOIN products_sku ON products_sku.size_id = products_sizes.size_id
WHERE products.enable_stock_management = '1'
AND products.products_id != '-11'GROUP BY products.products_id;

Upvotes: 1

Related Questions