Views as sub table

It would be helpful if a View could be utilized as a sub table.

My use case:

Tables: Campaigns and Companies.

Companies havea campaign_id from the campaigns table.

Campaigns can therefore have a list of companies.

Because Companies are not always Campaign Companies, renaming the table does not make sense.

But if I could create a View with a name of campaign_companies, that simply includes everything from the companies table, then I could utilize it as a sub table.

Community Page
Last updated: