16 Apr
2011
16 Apr
'11
12:39 p.m.
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