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/06/30 01:05:58
![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](/uploads/image/z/13868765-53-5.jpg?t=select+count%28%2A%29+from+archive_accessories+a+whereselect+count%28%2A%29+from+archive_accessories+a+where+not+exists%28select+%26%2339%3Bx%26%2339%3B+from+T_GL_IGNOREACC+b+where+a.accid%3Db.accid%29+and+%28acccontent+is+null+or+length%28acccontent%29%26gt%3B0%29+and+flag%3D%26%2339%3B4%26%2339%3B%3Band+e)
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的表;