Are joins along these lines supported?

MainTable <-- leftjoin <-- MappingTable <-- leftjoin <-- SecondaryTable

Assuming, of course, that appropriate fields exist in these tables such that I could perform such a join with a normal SQL statement.

I've tried to come at this several different ways, and I just don't see it.

Comments

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Murphysboro, IL, USA
CreditAttribution: mikeryan commented
Status: Active » Postponed (maintainer needs more info)

Have you created the necessary relationships in Table Wizard, on the Relationships tab? Then when creating a view starting from the MainTable, you should be able to add Relationships (top center of the edit form).