I have a database structure with the following tables:
gr_campuses
gr_enrollments
gr_programs
gr_industries
gr_districts
The gr_enrollments table contains the following relevant columns:
campus_id
program_id
district_id
However, the gr_enrollments table does not have a direct industry_id. Instead, the gr_programs table contains the industry_id that links to gr_industries.
The issue arises when I try to filter gr_enrollments by industry_id. Since industry_id is not directly available in the gr_enrollments table but is linked through gr_programs, the filtering operation does not work as expected.
Could you assist in resolving this issue or suggest the best approach to properly filter gr_enrollments by industry_id through the relationship with gr_programs?
I have a database structure with the following tables:
The gr_enrollments table contains the following relevant columns:
However, the gr_enrollments table does not have a direct industry_id. Instead, the gr_programs table contains the industry_id that links to gr_industries.
The issue arises when I try to filter gr_enrollments by industry_id. Since industry_id is not directly available in the gr_enrollments table but is linked through gr_programs, the filtering operation does not work as expected.
Could you assist in resolving this issue or suggest the best approach to properly filter gr_enrollments by industry_id through the relationship with gr_programs?