Forums

This topic is locked

Is it possible to use an IN clause to dynamically add tables?

Posted 08 Apr 2011 00:15:40
1
has voted
08 Apr 2011 00:15:40 Drew White posted:
Ok, here's what I'm trying to do. I'm working on a project where I retrieve a skill code from one table given an associate id. what I want to be able to do is retrieve all users, say, given a region business unit id and find all the users within that region that have multiple skill codes. For instance, I want to find a user that has 'Java', 'Oracle', 'DB2', etc where each skillset has its own skill code. I can use an IN clause but that will return a huge list of users who either have a 'Java' skillset OR an 'Oracle' skillset OR a 'DB2' skillset. I want to be able to pull back all the users who have a 'Java' AND 'Oracle' AND 'DB2' skillset. Does this make any sense to anyone???

Reply to this topic