Can not Select info from Previous Select

[lionroar]

i can not get that values for each skill, if any to display for the corresponding skill of a user.

i have a table of skills.

Table_Skills
ID
Skill
CategoryId

and a table for employee skills

Table_EMPL_Skills
UserID
SkillID
Rating
LastUsed
Years

What i am trying to accomplish is list out each skill. That is straight forward, each skill should be listed on the page reagrdless of anything else.

The other part where im haveing trouble is that for an employee, they may have selected only one of those skills, with its corresponding information Rating, LastUsed Years.

Therefore i still want to print out all skills reagrdless, but if an employee had information realted to one of those skills, i want to place that inforamtion next to that skill. thus all others would be blank, but the one or more skills that has inforamtion, would display that info for that skill and user.

i hope that makes more sense in what im trying to accomplish.

 

[Jonax]

I guess this is what you want:

SELECT UserID, (SELECT Skill FROM Table_Skills WHERE ID = ES.SkillId), Rating, LastUsed, Years FROM Table_EMPL_Skills ES

This is not a bug - it's an undocumented feature...
;-)

 

[lionroar]

That does work, somewhat, but when i have to run the select where id = some userid. it will still only give me back the recordsets that have that skill inforamtion not the full lsit of skills, with their corresponding information if any, for that particular user.

?????

 

[Jonax]

Do you have a User-table and with what columns? This is not a bug - it's an undocumented feature...
;-)

 

[lionroar]

yes i do

tbl_employee
UserID
LastName
FirstName
MiddleInitial
Email
Supervisor
Project
LogonName