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;