select lb_did from lab_details inner join lab_details_test on lb_id=lbdt_lb_id where lbdt_t_id='47' and lb_status='Active' group by lb_did CRP (C-Reactive Protein) Test - hindustanportal.com