Joining polymorphic tables


I have been trying to join a table with another which has got a
polymporhic set of columns. So I don’t know what would be there in
_type" column upfront. Moreover the join branches out based on what
is present in the "
_type”. For example I have a subscription model
like this:
Subscription{:user_id, :user_type)

There could be 2 types of users, Family or Friend. And these types of
users have a login which is stored in logins table.

How can I connect subscriptions table to logins table? My goal is to
use if it’s a family user and
subscription.friend.login if it’s a friend user.

If there was no polymorphic relation then I could’ve said:
“subscriptions s LEFT JOIN family f ON =”


This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs