Rar: Request For Docs

Documentation needed for this case:

Select all rows and columns from ‘main’ table joined to related table.

Join is required for ordering and filtering.

Related columns required for building result grid.

I think it’s a pretty common task.

The example I found here produces two queries: one for main table joined with related, and one for related table data, which is a little bit weird to me.