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

Reply via email to