>How can I change this query. Foxpro says.. nesting too deep
>
>
>SELECT DISTINCT sfolio FROM folio WHERE sfolio in(select memb_folio FROM demat WHERE qty_accept > 0 AND demat_no NOT in(select trfno FROM wcert))

A generic answer:

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