SELECT DISTINCT F.sfolio; FROM demat D; LEFT JOIN wcert W ON W.trfno=D.demat_no; JOIN folio F ON F.sfolio=D.memb_folio; WHERE D.qty_accept > 0 AND W.trfno IS NULL * or SELECT DISTINCT D.memb_folio sfolio; FROM demat D; LEFT JOIN wcert W ON W.trfno=D.demat_no; JOIN folio F ON F.sfolio=D.memb_folio; WHERE D.qty_accept > 0 AND W.trfno IS NULL