select lb_did from lab_details inner join lab_details_test on lb_id=lbdt_lb_id where lbdt_t_id='123' and lb_status='Active' group by lb_did PCV (Packed Cell Volume) Test - hindustanportal.com