一个 sql 语句如下:select id from( selec ....
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e
where 1=1 and exist ( select eventid from a where..e.e.r.e) as b order by datetime descexist走全表 ,我准备用inner join 替换结果总是失败 , 提示 2个 ( selec ....
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e( select eventid from a where..e.e.r.e) as b
不能用inner join (left right join都失败)问有什么方法啊可以不用exist
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e
where 1=1 and exist ( select eventid from a where..e.e.r.e) as b order by datetime descexist走全表 ,我准备用inner join 替换结果总是失败 , 提示 2个 ( selec ....
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e( select eventid from a where..e.e.r.e) as b
不能用inner join (left right join都失败)问有什么方法啊可以不用exist
and exist ( select eventid from a where..e.e.r.e) as b order by datetime desc
这个如何用in???