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:
Last updated: