l*0
2 楼
表是这样的:
id2 id3
1 1
1 2
1 3
2 1
2 3
3 2
4 1
4 2
我想查询这样的数据,就是同时满足id3=x和id3=y的id2
比如id3=1同时id3=2的id2有1,4
比如id3=1同时id3=3的id2有1,2
请问这条语句如何写(mysql)?谢谢!
id2 id3
1 1
1 2
1 3
2 1
2 3
3 2
4 1
4 2
我想查询这样的数据,就是同时满足id3=x和id3=y的id2
比如id3=1同时id3=2的id2有1,4
比如id3=1同时id3=3的id2有1,2
请问这条语句如何写(mysql)?谢谢!
c*d
3 楼
select a.id2
from
(select * from tabA where id3=x) as a,
(select * from tabA where id3=y) as b
where a.id2=b.id2
from
(select * from tabA where id3=x) as a,
(select * from tabA where id3=y) as b
where a.id2=b.id2
相关阅读
MCDBA, where is the braindump website for MCDBA?请问如何将Mysql database里的数据转化到Access里?Net8 Configuration AgentSQL2000XML questionMySQL数据库用户管理求助关于Sybase多对多relation?Re: Help!要不要相信professor?help! oracle8i client installation on Windows2000/NT4那里可以查询有关数据库原理的文档?Help!Import DB from Access97 to SQLserver 7.0.Oracle DBA 考试资料?MSQueryHow to concatenate NULL value with a string in SQL Server?菜鸟问题: 请问现在的数据库的远程管理能做到那些?是否可以完全取代本地机器的管理?WHY DB2的CONTROL CENTER出不来???Oracle Insert 语句求教求助:SQL Fulltext search不干活了。any tool helps import xml data into oracle?[转载] ODBC driver