I was in this state for years, thinking in an imperative way. The change for me was realising that your starting point is every possible combination of the row

I was in this state for years, thinking in an imperative way. The change for me was realising that your starting point is every possible combination of the rows in the tables. Just start with that (regardless of how massive) and then filter it down.