I need to generate an remote view to pull information from a table that would be equivalent to the following...
TABLE1
/ \
TABLE21 TABLE22
/ \
TABLE31 TABLE32
such that all records in TABLE1 pull even if there are no corresponding records in the subordinate tables. I can do one side with a LEFT JOIN, but I can't seem to do the two sides at the same time.
Where I would have one record returned for each one in TABLE1 and either populated or blank fields for the selected subordinate tables,
just as if I were to set rela to each of the tables and issue a
BROW FIELD TABLE1.FIELDx TABLE31.FIELDy TABLE32.FIELDz