I have the following query. There should be a record for each value in the sn.code portion of the where clause. I don't want 7 separate quires but I do need the seven records.
FROM SpecialNeedsXREF snx
JOIN SpecialNeeds sn ON snx.SpecialNeedID = sn.SpecialNeedID
where snx.ClientID = '633985' and sn.Code in ('1','2','3','4','5','6','7')