I've just been looking at Creating a Joined View layer to use in a web app for users, I know this is possible in the Classic Map Viewer (I had done my join in the current Map Viewer only to realize much later that it's not a view so it won't update).
This article outlines two options of how to do it. In Classic Map Viewer, you can pick any content you have access to regardless of owner in order to create this join view.
However, when I go to Create View from the item details page, when I get to Step 2, Choose Join layer, it will ONLY show content owned by the same user. Is this intentional? Am I missing something? (Is this related to the other ArcGIS Online issues I've been seeing this afternoon?)