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.