Hi Josh,
You need to have the tables in your data model, example:

And now on the screen you have a query and you have the joins by the foreign key:

The with or without represents a LEFT JOIN in SQL.
And on the UI part of the screen you add a list, bind it to the table and add content to it:

In my case I have a list item with an expression, coming from the query:

Hope it helps.
Cheers,
João