MSSQL 多表查询 去重复记录

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中的重复记录即可