T
Tanya
Hi I have the follow SQL for ranking multiple intelligence scores, then
selecting the top ranking. The next thing I want to do is match the top rank
with a description of that skill in a table called MI Descriptors - the table
4 fields only [ID] [SKILL] [DESCRIPTOR] [CAREER].
My question is do I need to create a union query of the query below or can I
simply add another column to this existing query? Any assistance would be
appreciated.
[Rank Query2]
SELECT a1.StudentID, a1.Skill
FROM MIUnionQuery AS a1, MIUnionQuery AS a2
WHERE (((a1.Score)<=[a2].[Score] Or (a1.Score)=[a2].[Score]))
GROUP BY a1.StudentID, a1.Skill, a1.Score
HAVING (((Count(a2.Score))=1));
Kind Regards
Tanya
selecting the top ranking. The next thing I want to do is match the top rank
with a description of that skill in a table called MI Descriptors - the table
4 fields only [ID] [SKILL] [DESCRIPTOR] [CAREER].
My question is do I need to create a union query of the query below or can I
simply add another column to this existing query? Any assistance would be
appreciated.
[Rank Query2]
SELECT a1.StudentID, a1.Skill
FROM MIUnionQuery AS a1, MIUnionQuery AS a2
WHERE (((a1.Score)<=[a2].[Score] Or (a1.Score)=[a2].[Score]))
GROUP BY a1.StudentID, a1.Skill, a1.Score
HAVING (((Count(a2.Score))=1));
Kind Regards
Tanya