Carl! Your rewrite of the query did the trick. I see how change it to use a join instead. I'm definitely not a SQL wiz :) Thanks!
Looking forward to trying out 0.5.0. On Tue, Feb 23, 2010 at 4:27 PM, Carl Steinbach <[email protected]> wrote: > Also, what happens if you rewrite the query using explicit JOIN syntax? > > SELECT rh.user_name, rh.report_name, rh.report_run_date > FROM > (SELECT max(report_run_date) as maxdate, report_name > FROM report_history > GROUP BY report_name) maxresults > JOIN report_history rh > ON (rh.report_name = maxresults.report_name AND rh.report_run_date = > maxresults.maxdata)
