To Join or not to join that is the question- and if so how

2001-05-25 Thread Stephen Kellogg
Hi all, I hope everyone's having a great Friday. I have several tables. Table 1 intCandidateID intB2bSalesIDFK bunch of fields Table 2 intIndID intCandidateIDFK industryIDFK intCandIndYrs I want to be able to search Table 1 for matching data AND table 2 for a candidate with a specific industry

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Russ Conway
Write your query using IN so it looks like this... select tblCandidates.* from {oj tblCandIndExp LEFT OUTER JOIN tblCandidates ON tblCandidates.intCandidateID = tblCandIndExp.intCandidateIDFK} where 0=0 AND tblCandIndExp.intIndustryIDFK IN (1,15) AND tblCandIndExp.intCandIndYrs IN (2,3) Order

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Bryan Love
] -Original Message- From: Stephen Kellogg [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 11:31 AM To: CF-Talk Subject: To Join or not to join that is the question- and if so how Hi all, I hope everyone's having a great Friday. I have several tables. Table 1 intCandidateID

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Mark Warrick
that is the question- and if so how Write your query using IN so it looks like this... select tblCandidates.* from {oj tblCandIndExp LEFT OUTER JOIN tblCandidates ON tblCandidates.intCandidateID = tblCandIndExp.intCandidateIDFK} where 0=0 AND tblCandIndExp.intIndustryIDFK IN (1,15

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Russ Conway
://www.hallofsports.com .. . . where the legends live on -Original Message- From: Russ Conway [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 2:43 PM To: CF-Talk Subject: RE: To Join or not to join that is the question- and if so how Write your query using IN so it looks like this... select

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Stephen Kellogg
-Talk Subject: RE: To Join or not to join that is the question- and if so how I'll assume that using IN is not an option because each experience field must be matched with it's corresponding years. That being said this query is not easy. You need to seperate each form field with OR and use

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Bryan Love
: Stephen Kellogg [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 2:05 PM To: CF-Talk Subject: RE: To Join or not to join that is the question- and if so how Thanks for the help. If I'm reading this correctly, it will select someone with experience in either industry but not ONLY people who match

RE: To Join or not to join that is the question- and if so how

2001-05-25 Thread Stephen Kellogg
. You've been a big help. Have a great weekend Stephen -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 5:43 PM To: CF-Talk Subject: RE: To Join or not to join that is the question- and if so how You did read my code correctly. If you wish