query
SELECT d.aggregator_id, d.model_id, CASE WHEN COUNT(r.tbl_demo_p_id) = d.quantity THEN 'Full' ELSE 'Empty' END AS status FROM tbl_demo d LEFT JOIN tbl_demo_refer r ON d.id = r.tbl_demo_p_id WHERE d.aggregator_id = 1 AND d.model_id = 2 GROUP BY d.aggregator_id, d.model_id, d.quantity;
SELECT
d.aggregator_id,
d.model_id,
CASE
WHEN COUNT(r.tbl_demo_p_id) = d.quantity THEN 'Full'
ELSE 'Empty'
END AS status
FROM
tbl_demo d
LEFT JOIN
tbl_demo_refer r ON d.id = r.tbl_demo_p_id
WHERE
d.aggregator_id = <aggregator_id_value>
AND d.model_id = <model_id_value>
AND r.car_no = '<car_no_value>'
GROUP BY
d.aggregator_id, d.model_id, d.quantity;
Comments
Post a Comment