27,579
社区成员
发帖
与我相关
我的任务
分享两个约束条件如何取交集??
取交集一般是: select * from table1 where exist (select * from table2 where column1='XXX')
但是用 select * from table1 where column2 ='YYY' exist (select * from table2 where column1='XXX')
就不能运行了,where exist不能分开,那怎么办呢,不想用临时表.
但是用 select * from table1 where column2 ='YYY' exist (select * from table2 where column1='XXX')
就不能运行了,where exist不能分开,那怎么办呢,不想用临时表.
...全文
请发表友善的回复…
发表回复
愉快的登山者 2005-02-05
- 打赏
- 举报
select * from table1
where column2 ='YYY'
and exist (select * from table2 where column1='XXX')
where column2 ='YYY'
and exist (select * from table2 where column1='XXX')
