case isnull((SELECT dbo.ctAdmissionType.InOrOut FROM dbo.meetings m INNER JOIN dbo.ctAdmissionType ON m.AdmitTypeID = dbo.ctAdmissionType.AdmitTypeID where m.meetingnumber=meetings.meetingnumber),0) when 1 then 'IN' else 'OUT' end as AdmitType