Am relatively new to the RoR world. My question is quite simple.
I have a query like such:
shipmentNumbers = Order.find_by_sql([“select distinct s.id from orders
o, line_items li, shipment_lines sl, shipments s where o.number=? and
o.id = li.order_id and li.id = sl.line_item_id and sl.shipment_id =
The above query works fine. I wanted to do the same query using the
shipmentNumbers = Order.find(:all,
:conditions => [“number = ?”, number],
:joins => “as o join line_items as li on o.id = li.order_id join
shipment_lines as sl on sl.line_item_id = li.id join
shipments as s on sl.shipment_id = s.id”)
In the above query I need to add the “distinct s.id” equivalent for
getting the correct results. Does anybody have an idea as to how I would
use the DISTINCT clause in the find(…) method?