Timothy Heald wrote: > Never heard of them, would you define them please?
Full outer join is a join preserving the unmatched rows from both tables. The NATURAL LEFT means that fields from the right table with equal names to fields from the left table will be dropped from the resultset thus returning just the content from the left table for that field (unless that is NULL and the content of the right table is not NULL, then the content from the right table is returned). Jochem ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
