管理员账号登录时可以查看所有内容(例如业务员a,b,c三个负责的所有客户内容),业务员登录的时候只可以看到12121负责的客户内容这个在数据集总怎么合并怎么写,麻烦各位大佬谢谢-- 管理员登录的时候显示获取这段sqlSELECT DISTINCT comp_id,typeFROM(SELECT pur,typeFROM aWHERE type=1 and acctid = 'admin'-- '${fine_username}') aINNER JOIN(SELECT DISTINCT comp_id,comp_name,com_id FROM b WHERE com_id NOT IN (SELECT cus_code FROM c) ) bON a.pur = b.com_id OR a.pur='-1'-- 业务员登录的时候获取这一段sqlSELECT DISTINCT comp_id,typeFROM(SELECT pur,typeFROM aWHERE (type = 7) and acctid = '12121'-- '${fine_username}') aINNER JOIN(SELECT DISTINCT comp_id,com_id FROM b WHERE com_id NOT IN (SELECT cus_code FROM c) ) bON a.pur = b.comp_id