Displaying 1 result from an estimated 1 matches for "us_state_sales1".
Did you mean:
us_state_sales
2009 Apr 16
0
how to convert the find_by_sql code to the find code
...l("SELECT z.state,
sum(s.royalty_price) as royalty_price, sum(s.units) as units FROM
sales_reports s, zip_codes z
WHERE royalty_currency = ''USD'' && z.zip_code=s.postal_code GROUP BY
z.state ORDER BY royalty_price desc LIMIT 10")
i try something like this
@us_state_sales1=SalesReport.find(:all, :select=>" zip_codes.state,
sum(sales_reports.royalty_price) as royalty_price,
sum(sales_reports.units) as units",
:joins=>''zip_codes'',
:conditions=>["royalty_currency = ''USD'' &&
zip_codes.zip_code=s.postal_...