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
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
]
-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
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
://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
-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
: 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
. 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
8 matches
Mail list logo