Thanks John

I did it this way. Problem was with subqueries

select d.dr_no, d.dp_code, f.sshares as shares, f.scertno as cert_no, ;
f.sstdistno as dist_no, f.sstdistno + (f.sshares - 1) as dist_no_to ;
from demat d, folio f  ;
WHERE sfolio = MEMB_FOLIO AND qty_accept > 0 AND demat_no NOT in(select trfno FROM wcert) into TABLE notfd

Rajesh


>Hi,
>I think the simplest way is break this SQL statement into 2.
>

>select memb_folio ;
>FROM demat WHERE qty_accept > 0 ;
>AND demat_no NOT in(select trfno FROM wcert) ;
>INTO CURSOR myCursor
>
>SELECT DISTINCT sfolio ;
>FROM folio ;
>WHERE sfolio in(SELECT memb_folio FROM myCursor)
>

>If you are using view, then you may create 2 views, each for SQL above (without INTO CURSOR clause).
>
>HTH