昨天的帖子:
http://topic.csdn.net/u/20120801/10/d5a2a894-f3a1-4808-8739-633054051aff.html?seed=459485272&r=79294856
麻烦帮我看看我后面提的问题怎么处理,谢谢!
------解决方案--------------------
这。。。。 被点名了
- SQL code
SELECT a.[Emp_Id],a.[name]FROM [DB_Emp] a,[DB_Emp_Like] bWHERE a.[Emp_Id]=b.[Emp_Id] AND b.[Like_No] IN (101,102,103)AND EXISTS( SELECT 1 FROM [DB_Emp_Like] WHERE [Emp_Id]=b. [Emp_Id] AND [Like_No] IN (101,102,103) GROUP BY [Emp_Id] HAVING COUNT(DISTINCT [Like_No])=3)/*Emp_Id name----------- ----5 赵刚5 赵刚5 赵刚(3 行受影响)*/