Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-09 : 09:21:47
|
Mahammad writes "I have a table SKILLS with fields USERNAME, COURSENAMEWrite a sql to find out all users who have courses c1 and c2and c3 in their skill set. SKILLS Username coursename U1 C1 U1 C2 U2 C1 U2 C2 U2 C3 U3 C1 U3 C3 SHOULD RETURN ONLY U2" |
|
|
|
|
|
user who have all the skills specified