I have these four tables
Titles are related to Authors via the Intermediate table
Authors are related to Publishers via Intermediate
T.ID -> I.SOURCE_ID to I.TARGET_ID -> A.ID
A.ID -> I.SOURCE_ID to I.TARGET_ID -> P.ID
Given a Title name I need the Author and Publisher Name
It's pretty straight forward to join two tables via a common intermediate but I'm no sure of the join for this scenario.