I'll give it a shot, someone tell me if I am right :)

An inner join is a 1 to 1 join where there must be data on both the left and
right side of the join in order to get a result set.  An outer join (either
left or right) can be a one sided join, meaning as long as there is data on
the side you specify it will generate a return set.

Is that about right?

Tim

> -----Original Message-----
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 8:55 AM
> To: CF-Community
> Subject: RE: Spam and movie week and no good, very bad interviews
>
>
> So what would be the definition for them, I know what they do, and how to
> use them, but don't really know the definition off hand.
>
> Robert Everland III
> Web Developer Extraordinaire
> Dixon Ticonderoga Company
> http://www.dixonusa.com
>
> -----Original Message-----
> From: e g [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 11, 2002 8:43 PM
> To: CF-Community
> Subject: Spam and movie week and no good, very bad interviews
>
>
> I get too much spam, all of it idiotic. I spend at
> least an hour on my other account just deleting junk
> mail and I only get about 50 messages a day. This
> account is refreshingly free of spam : ) and is only
> time-consuming because
> of the many oh-so-entertaining digest emails I get. Granted most of the
> problem is this horrible computer and the slow 56k modem but still I don't
> need anything enlarged, shrunk, bought, sold, nor does my credit need
> repair. Especially by strangers.
>
> I have seen 4 movies in a week. Very unlike me.
> Wednesday -- Dogma = wonderful. Saturday -- Lock,
> Stock, and Two Smoking Barrels = boring. Today --
> Spiderman and MIB II = very good (although sitting
> through a double feature was a bit of a trial.)  : )
> For some reason our Blockbuster doesn't have Best in
> Show at all and Mystery Men was MIA so I guess movie
> week is over for now. Besides, the new tv season is
> starting soon. Yea!
>
> I had an interview at what seemed to be a great
> company yesterday. Unfortunately they must think I'm
> an idiot. I couldn't even remember the most simple
> things - like the difference between an inner and an
> outer join. I just froze. Sigh....
>
> I'm going to go crawl in a hole and pull some dirt
> over me although I may take a couple of books with me.
> Maybe CF for Dummies and my big Oracle reference. ; )
>
> e
>
>
> __________________________________________________
> Yahoo! - We Remember
> 9-11: A tribute to the more than 3,000 lives lost
> http://dir.remember.yahoo.com/tribute
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> 
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to