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