I have a channel 1 and a channel 2. In channel 1 I have a relationship field that relate to channel 2.
I want (by making a query, for reasons I won't explain here because this is not important) to trace the content of a custom field (named "client") of the channel 2.
I know I have to look into
exp_relationships table but don't know how to build my query because the columns of
exp_relationships are not very relevant to me :D
What I have as material to use at this stage is the ID of the parent entry.
Anyone can help me on this please? Thanks in advance.