Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S3280'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S4217     '                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S4217     
 Enter Hehe 4  : 
 Enter Hehe 5  :