I belive by aliasing the table names on the join.
What I have is a table, that I would like to sum the totalyrs from three chosen
skills, and to count the total number of skill - both related to the same candidate.
Can be done - but I can not get my mind to hold this slippery fish long enough to get
the ah ha!
Stephen R. Cassady
[EMAIL PROTECTED]
http://www.ububik.com
http://www.tallylist.com <--- cause' you no you wannnnnnnna!
----- Original Message -----
How can you do a join on the same table? Both of these queries are drawn from the
CandidateSkills table? Am I misunderstanding your question?
----- Original Message ----- From: "cassady " <[EMAIL PROTECTED]> To: "CF-Talk"
<[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 9:22 AM Subject: Query
Join Brain Fart
> Hey everyone - > Arrgh. I haven't done any of these in a while, and I'm having a
>little bit of a brain fart. Could somebody put these together in a join when the SQL
>table returned has the following columns: > > CandidateID, Num_Skills, BM_score > >
>If I get the example then I think (hope? dream?) that my brain might start
>functioning again like it should. :-) > > > <!--- For Number of Skills ---> >
><cfquery name="q_BM_score" datasource="datasource"> > Select CandidateID, Count(*) AS
>num_skills > From CandidateSkills > Where CandidateSkills.CandidateID IN
>(#ListCandidateID#) > Group By CandidateID > </cfquery> > > > <!--- Query for skill
>points ---> > <cfquery name="q_BM_score" datasource="datasource"> > Select
>Sum(ExpYears) AS BM_score > From CandidateSkills > Where CandidateSkills.CandidateID
>= #Client_saSearch.CandidateID# > AND ((CandidateSkills.SkillID = #Skills1#) > OR
>(CandidateSkills.SkillID = #Skills2#) > OR (CandidateSkills.SkillID = #Skills3#)) >
></cfquery> > > Thank you for your time in advance, > Stephen R. Cassady >
>[EMAIL PROTECTED] > http://www.ububik.com > http://www.tallylist.com <--- cause' you
>no you wannnnnnnna! > > > >
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
