RGs with multiple tables

Hi looking to produce a list of sortable jobs where the list is filtered by company industry.

Here are the tables

I have worked out that i can use a RG of jobs by company inside a RG of companies by industry but that will only le me sort the jobs for each company rather than across all of the jobs of all industry-filtered companies ?

Any ideas?

Thanks in advance