Untitled

SELECT	person.person_nameFROM	program, cast, person, cast_person, cast_person_roleWHERE	program.cast_id=cast.cast_idAND	cast.cast_id =cast_person.cast_idAND	person.person_id=cast_person.person_idAND	person.person_name = 'bob';