Table Join HELP!

[Anon]

I have three tables in a normalized db.

user | relUserSkill | skill

----------------- + ----------------- + ---------------------
userID(primKey) | skillID | skillID (primKey)
| userID |
| relID (primKey) |

The user and skill tables are related via the relUserSkill table.

Each user has a relationship to the skills that they posess which is documented in the relUserSkill table. Each user can have many skills and each skill can be had by many users.

I'm not sure how to write a select statement that will generate all the skills for a specific user. I know I have to use a join to do this, but I need some help. Do I have to do more than one select?

Many Many Thanks,
matt.

[Anon]

Sorry, the formatting didn't work out my last msg, this should look better:

I have three tables in a normalized db.

---

table: user
userID(primKey)

---

table: relUserSkill
relID(primKey)

userID
skillID

---

table: skill
skillID(primKey)
name

---

The user and skill tables are related via the relUserSkill table.

Each user has a relationship to the skills that they posess which is documented in the relUserSkill table. Each user can have many skills and each skill can be had by many users.

I'm not sure how to write a select statement that will generate all the skills for a specific user. I know I have to use a join to do this, but I need some help. Do I have to do more than one select?

Many Many Thanks,
matt.

[Anon]

SELECT u.
,r.
,s.*
FROM user u
,reluserskill r
,skill s
WHERE s.skillid = r.skillid
AND r.userid = u.userid
AND u.userid = 'user';

This should work !

Replace * with desired cols

JBL