权

摘要： SELECT ai_id,ai_mobile FROM dbo.ACCOUNT_INFO WHERE ai_id IN (SELECT DISTINCT ppi_ai_id FROM dbo.PAY_POS_INFO) AND ai_mobile_is_cfm=10注释: 因为PAY_POS_INFO表中存在多个相同的AIID,所以先去除表PAY_POS_INFO中的重复记录即可 阅读全文