Hi Robbie, Thanks for reply. This will work , but it will give employess who has either PHP or Java skill or both. What I wanted is , result should give employess having both PHP and Java skill. I figured it out, the syntax should be as below. SELECT EmployeeID FROM `table` WHERE `skill` IN ('PHP','Java') GROUP BY EmployeeID HAVING COUNT(*) = 2 This query's result gives employee ids who has both PHP and Java skills. The link http://stackoverflow.com/questions/4049650/what-sql-query-for-multiple-rows-... was really helpful. Thanks a lot for helping me. Regards Austin. On Sat, Apr 16, 2011 at 5:17 PM, Robbie The Geek <robbiethegeek@gmail.com>wrote:
SELECT EmployeeID FROM {tablename} WHERE Skill IN ( 'PHP', 'Java');
----- Reply message ----- From: "Austin Einter" <austin.einter@gmail.com> To: <development@drupal.org> Cc: "Jason Flatt" <drupal@oadaeh.net> Subject: [development] SQL Query Doubt Date: Sat, Apr 16, 2011 7:33 am
Hi Thanks for reply.
I have tried SELECT EmployeeID FROM {tablename} WHERE Skill = 'PHP' AND Skill = 'Java'; . It does not work. Probably in SQL in same row of table both values are not matching. Regards, Austin On Sat, Apr 16, 2011 at 4:54 PM, Jason Flatt <drupal@oadaeh.net> wrote:
On Sat, 16 Apr 2011 16:09:59 +0530 Austin Einter <austin.einter@gmail.com> wrote:
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.
SELECT EmployeeID FROM {tablename} WHERE Skill = 'PHP' AND Skill = 'Java';
This might help a bit: http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html
-- Jason Flatt Custom Website development solutions: http://www.oadaeh.net/ Father of seven: http://www.flattfamily.com/ (Joseph, 18; Cramer, 16; Travis, 14; Angela; Harry, 10; William, 5; and Dolly, 2) Linux user: http://www.ubuntu.org/ Android user: http://www.android.com/ Drupal fanatic: http://drupal.org/