Re: [development] SQL Query Doubt

[Rob Thorne]

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