>> Much of my prior >> experience was with xBase and once tables were related to >> each other, all >> one had to do was specify the field name in the child >> table and the correct >> related record was selected.
> I think that gets very ugly with self-referencing tables > and recursive queries. I can vouch for that. I've done a good share of nested tree stuff and self-referencing tables would be a nightmare without having to explicitely express your relationships in the query -- but then that's what views are for. Once you've written the relationship into a view, you can use that view over and over and not have to worry about it. I generally try to keep my number of views to a minimum, relating anything that's commonly used in a single view for the core table, and then use stored procedures for most specialty queries. The acception is when I have to create a really complex query with an IN statement because I cant use a sub-query or another join, then I will often resort to creating another view for the query that's going to need the IN statement. I also have created another view in the rare case in which I actually want a cartesian result set with a 3rd or 4th table joined on columns in either of the core tables creating the cartesian, which is another situation in which you don't want the db assuming relationships, but that's a whole other story. :) s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
