Re: Convert Subquery - need to find max of a set

2005-10-14 Thread Kristen G. Thorson
[EMAIL PROTECTED] wrote: "Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS description, FROM selector_forms

Re: Convert Subquery - need to find max of a set

2005-10-14 Thread SGreen
"Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: > I need to convert this query into one without a subquery: > > SELECT > r.selector_forms_results_max_points AS points, > r.selector_forms_results_description AS description, > FROM selector_forms_results AS r > WH

Convert Subquery - need to find max of a set

2005-10-14 Thread Kristen G. Thorson
I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS description, FROM selector_forms_results AS r WHERE r.selector_forms_id = 1 AND r.selector_forms_results_max_points = ( SELECT DI