IL PROTECTED]>
Sent: Thursday, October 14, 2004 8:41 AM
Subject: Re: Q: outer join w/restriction
> In article <[EMAIL PROTECTED]>,
> "Martin Gainty" <[EMAIL PROTECTED]> writes:
>
> > "You should generally not have any conditions in the ON part that are
In article <[EMAIL PROTECTED]>,
"Martin Gainty" <[EMAIL PROTECTED]> writes:
> "You should generally not have any conditions in the ON part that are used to
> restrict which rows you want in the result set, but rather specify these conditions
> in the WHERE clause"
> Forgive me for following the
PROTECTED]
To: Martin Gainty
Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 10:33 AM
Subject: Re: Q: outer join w/restriction
Martin, you are correct in how you determine when to use AND and when to use OR, but
that's not what the original query was
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 13, 2004 10:33 AM
To: Martin Gainty
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Q: outer join w/restriction
Martin, you are correct in how you determine when to use AND and when to
use OR, but
> ~John Nash PhD~
> ----- Original Message -
> From: "Harald Fuchs" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, October 13, 2004 8:37 AM
> Subject: Re: Q: outer join w/restriction
>
>
> > In article
>
<[EMAIL
sage -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 13, 2004 8:37 AM
Subject: Re: Q: outer join w/restriction
> In article
<[EMAIL PROTECTED]>,
> "Christopher J. Mackie" <[EMAIL PROTECTED]> writes:
&g
Sadly, it was a typo in the email (apologies for that), but not in the
query:
SELECT Applicants.AppID, Applicants.Name, Applicants.Email,
Reviews.Quant, Reviews.Qual
FROM ApplicantStatus
INNER JOIN Applicants ON Applicants.AppID = ApplicantStatus.AppID
LEFT JOIN Reviews ON Reviews.AppID
In article <[EMAIL PROTECTED]>,
"Christopher J. Mackie" <[EMAIL PROTECTED]> writes:
> There's something I'm not getting about how to put a SELECT restriction on a query
> with an outer join. The following query:
> SELECT Applicants.AppID, Applicants.Name, Applicants.Email,
> Reviews.Quant, Revi
There's something I'm not getting about how to put a SELECT restriction on a query
with an outer join. The following query:
SELECT Applicants.AppID, Applicants.Name, Applicants.Email,
Reviews.Quant, Reviews.Qual
FROM ApplicantStatus
INNER JOIN Applicants ON Applicants.AppID = ApplicantStatus.A
