Çó×î¼òSQL»òÊǸüºÃµÄ½â¾ö·½°¸

ÏÖÔÚÓÐÁ½¸ö±í Ô±¹¤Employee£¨Guid,Name£© ¼¼ÄÜSkill(Guid,Name,EmployeeGuid)
SkillµÄEmployeeGuid¹ØÁªÔ±¹¤£¨Employee£©±íGuid

ÏÖÒª²éѯԱ¹¤¼ÈÓÐCVSµÄ¼¼ÄÜÓÖÓÐJSFµÄ¼¼ÄÜ¡£ÒÔÏÂÊǸöÈ˲éѯsql¡£
Çó¸ßÊÖÊÇ·ñÓиüºÃµÄ½â¾ö°ì·¨£¨sql,´æ´¢¹ý³Ì¶¼¿ÉÒÔ£©


SQL code:
SELECT emp.Guid, emp.Name
from Employee emp
where
exists
(
select sk.Name from Skill sk where sk.EmployeeGuid = emp.Guid and sk.Name = N'CVS'
)
and
exists
(
select sk.Name from Skill sk where sk.EmployeeGuid = emp.Guid and sk.Name = N'JSF'
)

---

SQL code:

SELECT a.*
from Employee as a, Skill as b
where a.Guid=b.EmployeeGuid
and b.name='cvs' and b.name='jsf'

---

SQL code:

SELECT emp.Guid, emp.Name
from Employee emp left join Skill sk
on sk.EmployeeGuid = emp.Guid
where sk.Name in( N'CVS',N'JSF')

---

ÒýÓÃ

SQL codeSELECT a.*from  Employeeas a,  Skillas bwhere a.Guid=b.EmployeeGuidand b.name='cvs'and b.name='jsf'

up

---

SQL code

---

Code highlighting produced b