select CONTRACT.BATCHNO,CONTRACT.ICONTRACTNO,ACCT_CUST.INVESTNAME,ACCT_CUST.CERTIFICATETYPE,ACCT_CUST.CERTIFICATENO,CONTRACT.INVESTORMOBILETELNO,CONTRACT.INVESTORMOBILETELNO2,CONTRACT.INVESTOREMAIL,ACCT_BANK.BENEFITACCTNO,ACCT_BANK.BENEFITACCTNAME,ACCT_BANK.BENEFITBANKCODE,ACCT_BANK.BENEFITBANKNAME from ACCT_BANK,CONTRACT,ACCT_CUST where CONTRACT.CUSTNO=ACCT_CUST.CUSTNO AND ACCT_BANK.CUSTNO=ACCT_CUST.CUSTNO
如题 语句怎么写?
------解决方案--------------------
select count(*) from ACCT_BANK,CONTRACT,ACCT_CUST where CONTRACT.CUSTNO=ACCT_CUST.CUSTNO AND ACCT_BANK.CUSTNO=ACCT_CUST.CUSTNO