SELECT P.PersonID, P.FirstName, P.MiddleName, P.LastName, P.Gender, P.DOB, ( select top 1 Address1 from people where personid=P.father ) as FAddress , ( select top 1 Address1 from people where personid=P.mother ) as MAddress , (select case ( select top 1 CellPhone from people where personid=P.father) when '' then '-' else ( select top 1 CellPhone from people where personid=P.father) end) as FCellPhone , (select case ( select top 1 CellPhone from people where personid=P.mother ) when '' then '-' else ( select top 1 CellPhone from people where personid=P.mother ) end) as MCellPhone, etc.