September 13, 2005 at 1:46 pm
Apologies for the cross post but I really wasn't sure whether to post this in the "New to SQL Server" section (which I am) or this section (as it's T-SQL) - I don't normally cross post in any forum so I am sorry.
Anyway, I've got three tables that I'm querying:
1) CandidateDetails (contains a CandidateID, name etc)
2) Qualifications (contains a QualificationID, and Qualification name etc)
3) Candidate_Qualifications (contains a CandidateID and QualificationID which obviously stores details of what qualifications a candidate has).
What I'm trying to get is a list of candidates that have qualifications A, B, and C (i.e they MUST have ALL of those qualifications) and who preferably have qualifications D and E.
At the moment all I've been able to get is either a list of candidates who have any of the 'must-have' qualifications, but not necessarily all of them, or nothing - please help me (and excuse my ignorance - as I say, I'm still learning)
Thanks in advance
Martin
September 13, 2005 at 1:49 pm
Please do not cross-post as we monitor all the boards.
I already answered that question here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=219329
September 13, 2005 at 2:28 pm
Sorry (again!) - you beat me to it, was just about to post that it'd been answered elsewhere. Like I said in the posting, wasn't really sure where to post it but will just take a best-guess next time and leave it in one forum.
Thanks again for your help - really appreciate it.
Martin
September 13, 2005 at 2:48 pm
NP, HTH.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply