[development] SQL Query Doubt

[Austin Einter]

Hi All

Lets say I have one table in below format.

EmployeeID.............. Skill
------------------------------------------------------
1...............................PHP
1...............................SQL
1...............................Java
1................................VoIP

2................................Shell Scripting
2................................PHP
2................................Java

3............................... C++
3................................C
3.................................Pearl

I wan to do a SQL query for employess who MUST have skill PHP and Java.
As per above table, the query result should show Employee 1 and 2.

Now what should be the corresponding SQL query for it.

Regards
Austin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20110416/e7858311/attachment.html