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