select count(*) from archive_accessories a whereselect count(*) from archive_accessories a where not exists(select 'x' from T_GL_IGNOREACC b where a.accid=b.accid) and (acccontent is null or length(acccontent)>0) and flag='4';and e
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/28 22:53:41
select count(*) from archive_accessories a whereselect count(*) from archive_accessories a where not exists(select 'x' from T_GL_IGNOREACC b where a.accid=b.accid) and (acccontent is null or length(acccontent)>0) and flag='4';and e
select count(*) from archive_accessories a where
select count(*) from archive_accessories a where not exists(
select 'x' from T_GL_IGNOREACC b where a.accid=b.accid)
and (acccontent is null or length(acccontent)>0) and flag='4';
and exists(select 'x' from archive_store_info b where a.arid=b.storeid)
报错.啥情况啊
select count(*) from archive_accessories a whereselect count(*) from archive_accessories a where not exists(select 'x' from T_GL_IGNOREACC b where a.accid=b.accid) and (acccontent is null or length(acccontent)>0) and flag='4';and e
查询子句中有两个别名叫b的表;