Timothy Heald wrote:
> 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.

How about a FULL OUTER JOIN and a NATURAL LEFT OUTER JOIN :)

Jochem

______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com

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

Reply via email to