MySQL doens't have view support until 5.0, and that's only been out for a few weeks, so I'm going to wager he's probably not running it. Lot of places still run 3.23 for some unknown reason. Using subqueries in the FROM clause (which MySQL 4.1 supports) gets you down that track to some extent, though without the optimizations and reuse of a real view.
cheers, barneyb On 11/8/05, John C. Bland II <[EMAIL PROTECTED]> wrote: > If you have that much data why not create a view for each one then a view to > pull them together? That cut down on confusion. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223652 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
