求最简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