Thanks for your interesting answers. I'm sorry for not expressing myself clearly enough.
I need "join between databases" and "order by". Better example: Give me the list of all pets ordererd by their owners name. SELECT B.Pets.Name, A.Humans.Name FROM B.Pets JOIN A.Humans ON B.Pets.Owner_ID=A.Humans.ID ORDER BY A.Humans.Name Is this possible to express in Models, as Gavin did? class Human < Sequel::Model(A[:humans]) one_to_many :pets, :key=>:owner_id end class Pet < Sequel::Model(B[:pets]) many_to_one :owner, :class=>:Human, :key=>:owner_id end Or does "join" imply abandoning Models altogether? /Christer --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
