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
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 subscription.family.login 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 s.id = f.id”