i can manage the MySQL queries into active record.but in some cases
basically with sub-queries.i didn’t get the correct output.
here when i trying to change the MySQL queries into active-record.
select count() from ( SELECT transactions.loyalty_id FROM transactions
JOIN loyalties ON (transactions.loyalty_id = loyalties.id) where
loyalties.created_at > ‘2011-11-02’ GROUP BY transactions.loyalty_id
COUNT()>1 ) as t
Here just i tried to convert into corresponding active record queries.
i didn’t get the correct output.
Transaction.count(:loyalty_id) , :joins=> [“JOIN loyalties ON
(transactions.loyalty_id = loyalties.id)” ] , :conditions =>
["loyalties.created_at > ? ",cdate], :group=>
:having=> ["count() > 1 "] )*
How to change that issue?