How do I aggregate multiple rows of a joined table in SQL?
I have query 2 tables: jobs and jobs_filters. The jobs_filters is a M-M table to reference between jobs and filters. It contains job_id and a filter_id.
Currently when I query the tables I get back a lot of rows (many filters for each job). How do I aggregate filter_id into a list, so there would be only 1 row per a job?
Currently when I query the tables I get back a lot of rows (many filters for each job). How do I aggregate filter_id into a list, so there would be only 1 row per a job?
