select * from comment c left join article a on c.art_id=a.art_id where c.is_show=1
select * from comment as c left join article as a on c.art_id=a.art_id where c.is_show=1应该相同结果啊。建议楼主能提供 create table , insert into 的测试用例。
select * from comment as c left join article as a on c.art_id=a.art_id where c.is_show=1应该相同结果啊。建议楼主能提供 create table , insert into 的测试用例。
不应该存在相关问题,建立检查SQL语句