I need to write a custom query against the
exp_channel_data table. However, one of the channel's field is a relationship field. How do I track that back to the appropriate column in the
I've looked in the
exp_channel_fields table and found the relationship's
field_id (say it's 10). However, when I look
field_id_10, I just see some number in it. I was hoping it would give me the entry id of the row it's related to. Any ideas how to do this? I'm trying to do a JOIN based on the entry id.