Hi,

I'm trying to get some data using Views (Drupal 8), and I'm having difficulty understanding how to set up my Relationships across 3 content types. Relating it to SQL here's an example of what I'm trying to do:

Table A
-------
aID
bID (foreign key)

Table B
------
bID

Table C
------
cID
aID (foreign key)

SELECT TableA.*, TableB.*, TableC.*
FROM TableA
JOIN TableB
ON TableA.bID = TableB.bID
JOIN TableC
ON TableC.aID = TableA.aID
WHERE TableB.bID=$queryParamAID

On the url, I provide the queryParamAID which I assume I use the Contextual Filter. I assume the Relationships would be how I relate the tables.

What I should end up with are a list of items from Table C filtered by aID which I looked up using the bID.

Thanks.