here are my two tables
I want to get the entire list of table 'radio' with an additional column that tells me if a certain staff (staff_id) is in the radioshow. 1 if the staff is in, and 0 if it is not. I know to get a complete list of radio, I need to do a LEFT JOIN. But I don't know how to put in a conditional statement in the query.
I'm using MySQL 4.0.