16 Apr
2011
16 Apr
'11
11:29 p.m.
On 04/16/2011 05:28 AM, Ivan Sergio Borgonovo wrote:
select t1.eid from test.employee t1 join test.employee t2 on t1.eid=t2.eid where t1.skill='Java' and t2.skill='PHP' group by t1.eid ;
You can do a little better than that, I think, but a similar idea: select t1.ed from employee t1 inner join employee t2 on t1.eid = t2.eid and t2.skill = 'Java' where t1.skill = 'PHP'; No need for the group by.
1 2