I find subqueries really help this sort of thing, because they let you break a complex problem down into smaller pieces that can be solved (and tested!) individually. One of the best "work" days in the past few years was when we upgrade to MySQL 4.1 and got subquery support. Probably second only to the upgrade from CF4.5 to 6.1 (for obvious reasons).
Once you have a solution, then you can worry about making it more performant. Maybe compact a subquery into a join, maybe do the reverse. Stuff like that. Of course, only wasting time on that stuff if it's warranted by profiling. cheers, barneyb On 11/8/05, Les Mizzell <[EMAIL PROTECTED]> wrote: > I'll work with this tomorrow and let you know what happens. In the > "real" query, there's another 4 tables that data has to be filtered by > and selected from! It gets pretty wild looking.. > > Thanks for taking time to look at this... > -- 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:223651 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
