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

hanks a million. 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 correc

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

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 both. industry = 10 and years >= 4 OR industry =

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

01 3:02 PM To: CF-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

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

://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

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

Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net > -Original Message- > From: Russ Conway [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 25, 2001 11:43 AM > To: CF-Talk > Subject:

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

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 intB2bSalesIDFK bunch of fields Table 2 intIndID intCandidateIDFK industryIDFK i

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 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 by

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 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 a