SQL Multiple Reference Tables Question - Thanks

2003-03-01 Thread Adam Cantrell
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

Re: SQL Multiple Reference Tables Question - Thanks

2003-03-01 Thread Dina Hess
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

Re: SQL Multiple Reference Tables Question - Thanks

2003-02-28 Thread James Brown
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