Complicated Join...
Posted: Fri Oct 24, 2008 12:38 pm
I'm having trouble wrapping my head around how to do this...
So I've got three tables, directors, commercials, commercial_categories
Each commercial has a director_id and a commercial_category
How do I query all the directors with their commercial_categories, but only if commercials exist in that director's category? The original programmer of the site never created a table that links directors to commercial_category. Is there any way around this?
So I've got three tables, directors, commercials, commercial_categories
Each commercial has a director_id and a commercial_category
How do I query all the directors with their commercial_categories, but only if commercials exist in that director's category? The original programmer of the site never created a table that links directors to commercial_category. Is there any way around this?