今日写sql发现一个问题,sql语句如下:
(1)
select count(1)
from t_project_info p
left join t_code_value tcv_pt
on p.project_type = tcv_pt.key
where tcv_pt.parentid = 'project_Type';
(2)
select count(1)
from t_project_info p
left join (select * from t_code_value t where t.parentid = 'project_Type') c
on p.project_type = c.key;
(1)和(2)结果不同。
表tcv_pt条件不能放在外面,应按(2)方法或写在"on" 条件后面。