Is it possible to do a join on a table where the contents of the join field are comma separated list. So for example I want to do a join on the table below:
count(featured_jobs.id) AS featured
INNER JOIN companies ON companies.id = jobs.company_id
[B]INNER JOIN industries ON industries.id = jobs.industry[/B]
LEFT OUTER JOIN featured_jobs ON featured_jobs.job_id = jobs.id
WHERE jobs.status = 'on'
GROUP BY jobs.id
ORDER BY featured DESC , date_posted DESC
LIMIT 0 , 30
I want to get the industry name and the industry is stored by id (but there can be more that one and the IDs are separated by comma).. For example the contents of the jobs.industry might be "1011,1016,1090"
Can I do a join in this way?