You don't know how many times I've tried to tell our so called 'dba' that. At this location, we're joining views upon view upon views. I was trying to debug one view that was #8 in a succession of views, and each one of those was made up of at least 3 joins inside.
Marlon jon hall wrote: >Well the fact that you are joining two views might have something to >do with it...why not bypass the whole view routine and build a new >view altogether, and see if that fixes it? > >Maybe it's just me, but joining views seems counter to the purpose of >a view anyway. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
