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
