Chained/nest joins?

Are joins along these lines supported?

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

I've got something like this set up using the UI, but no info from the SecondaryTable shows up when I try to build a View based on the MainTable.

Or can only one SecondaryTable be joined to the MainTable? As it happens, I've got this relationship already working:

MainTable <-- leftjoin <-- SomeOtherTable