Modeling Optional Column
question is not clear to me but this might be what you are looking for  

select l.license_num, cr.course_topic_code, cr.required_minutes
from Course_Requirements cr
join Licensees l on cr.license_level = l.license_level
                and cr.residential = isnull(l.residential,1);