Use of Joint Cartesian Join and Left Join in Subselect to Accomplish Value Override
This post details how to accomplish a cross-join between two tables and left join in the many-to-many to override a value in the left most table. The result is a dynamic setting view in which each target section pulls from a base of setting values, but may override the default value with it's own value. There is also an example of using this model for a dynamic cascading heirarchy of settings in coldfusion.
[Read More]