In the EE database, I see that
field_id = 4 refers to a relationship in my
Channel-A (channel_id = 1). I assume that channel data for that field should be stored in my
field_id_4. Is this right? I do not see any data in that column, despite me going into Channel-A and making sure that I have selected a value from the relationship field.
I'm trying to build a query that gets a distinct list of url titles from the relationship field if that title was selected in Channel A.