ejbbank_listcredits.sqx

噶额外噶外骨骼感广泛高热感 就 啊啊

<?xml version="1.0"?>

<Query>
<Schema>Con2_EJBBANK.dbxmi</Schema>

<SelectStatement>
<![CDATA[

SELECT 
   ITSO.CUSTOMER.CUSTOMERID, 
   ITSO.CUSTOMER.TITLE, 
   ITSO.CUSTOMER.FIRSTNAME, 
   ITSO.CUSTOMER.LASTNAME, 
   ITSO.CUSTOMER.USERID, 
   ITSO.CUSTOMER.PASSWORD, 
   ITSO.TRANSRECORD.TRANSID, 
   ITSO.TRANSRECORD.ACCID, 
   ITSO.TRANSRECORD.TRANSTYPE, 
   ITSO.TRANSRECORD.TRANSAMT
FROM
   ITSO.CUSTOMER, ITSO.CUSTACCT, ITSO.TRANSRECORD
WHERE
   ITSO.CUSTOMER.CUSTOMERID = ITSO.CUSTACCT.CUSTOMERID 
   AND ITSO.CUSTACCT.ACCID = ITSO.TRANSRECORD.ACCID 
   AND ITSO.TRANSRECORD.TRANSTYPE = :type  
   AND ITSO.CUSTOMER.LASTNAME LIKE :lastname 
]]>
</SelectStatement>
</Query>