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