James, Dina is correct - 'LEFT JOIN' is the same as 'LEFT OUTER JOIN' for most
RDBMS's. Some will actually require LEFT OUTER JOIN, but I think that's rare these
days. The LEFT/LEFT OUTER is more loose - it's like telling the DB:
"give me all the records in the left table, and then if there are
quot;James Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 4:30 PM
Subject: Re: SQL Multiple Reference Tables Question - Thanks
> This is the answer. Many thanks.
>
> James Brown
>
> - Original Messa
This is the answer. Many thanks.
James Brown
- Original Message -
From: "Cantrell, Adam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 4:41 PM
Subject: RE: SQL Multiple Reference Tables Question
> This may work, you'll want to look into using cfq
3 matches
Mail list logo