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
