Displaying 1 result from an estimated 1 matches for "download_date".
Did you mean:
download_base
2009 Apr 16
0
how to convert the find_by_sql code to the find code
...; 10)
but it gives me the following error ......
Mysql::Error: Unknown column ''zip_codes.state'' in ''field list'': SELECT
zip_codes.state,sum(sales_reports.royalty_price) as royalty_price,
sum(sales_reports.units) as units FROM `sales_reports` zip_codes WHERE
(download_date BETWEEN ''2010-01-01 00:00:00'' AND ''2010-12-31 00:00:00''
&& artist_name in ("Coconut Records","Reeve Oliver","Weezer") &&
royalty_currency = ''USD'' && zip_codes.zip_code=s.postal_code) GROUP B...