I've got something in my app that I'd like to rework to use a view. Basically (I'm using CF here) I do a few queries on a given table, using count() or distinct to pull various values, with different criteria for each query.
I'd *like* to be able to combine all this noise into a view, so instead of having to query the DB for these values each time, the DB just kinda "keeps up" with these values and I can pull'em out quickly. Trick is, I don't see a way to create a view where one column is the value of a query, and the next column is the value of a DIFFERENT query, etc. Is this even possible? And if not, any recommendations on an alternate method? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2752 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
