17,086
社区成员
发帖
与我相关
我的任务
分享
select * from Z where z.id in (select id from X)
UNION
select * from Z where z.id in (select id from Y WHERE 0 = (SELECT COUNT(ID) FROM X))
select * from test3 where id in (select id from test1 union select id from
test2,(select count(1) count from test1) where count=0);