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
