1. 无效
select * from term_info
where 1 = 1
AND
company_no = 2
and term_no not in ( select GROUP_CONCAT(term_no) from p_info where company_no = 2 and id != 1 )
where 1 = 1
AND
company_no = 2
and term_no not in ( select GROUP_CONCAT(term_no) from p_info where company_no = 2 and id != 1 )
2. 有效
select * from term_info
AND
company_no = 2
and not INSTR(( select GROUP_CONCAT(term_no) from p_info where company_no = 2 and id != 1 ) ,term_no)
INSTR(1,2)
但是有一个问题就是如果1为空,那么,查出来的数据就不对,需要加ifnull 判断为:
SELECT
*
FROM
term_info
WHERE
1 = 1
AND company_no =1
AND NOT INSTR(
IFNULL((
SELECT
GROUP_CONCAT(term_no)
FROM
p_info
WHERE
1 = 1
AND company_no = 1
AND id != 1
),''),
term_no
)