权

摘要： SELECT * FROM ( SELECT TOP 20 ppab_account,ppab_payee_ai_id, (CASE WHEN (ppab_payee_ai_id!=0 OR ppab_payee_ai_id is NOT NULL) THEN ( SELECT TOP 1 ai_cnname FROM account_info WHERE ai_id=ppab_payee_ai_id ) ELSE '''' END ) AS ai_cnname, COUNT(ppab_account) AS 'ppab_count' ,SU.. 阅读全文