On Oct 2, 7:33 am, craig mcmillan <[email protected]> wrote: > hi, > > i've been trying to figure out how to avoid dataset column-key clashes > when the dataset is on a join. > > e.g. > > db[:message_infos].join(:identities, {:id=>:author_identity_id}) > > if both :message_infos and :identities tables have an :id column, the > result has only a single :id column-key and values from one of the :id > columns are lost > > can i simply alias columns in joined tables ?
Yes. Or you can use .graph instead of .join, which is easier but has slightly different results. Jeremy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
