Does anyone have an example of using a pivot relation with table view?

[Otisssss]

I have a pivot and want to include values within the table from the join. I have not seen it in the documentation so before I dive it, first is this even possible? Example...Select lead.id, user.id join lead_user. In table have columns lead_name, user_name which can both be clickable to proper records? Thanks in advance.