here are my two tables

table: radio
radioshow_id
name

table: radio2staff
radioshow_id
staff_id

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.