sub query issue with active record.

amvis
2011-12-27T14:16:24Z

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.

*MySQL Query*

*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 HAVING
COUNT(*)>1 ) as t*

Here just i tried to convert into corresponding active record queries. But
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=>
["transactions.loyalty_id"],
:having=> ["count(*) > 1 "] )*

How to change that issue?

--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/VT9PqxKYyLEJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at