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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
