SELECT O.Id, S1.Value AS Family, S2.Value AS FirstName,
      S3.Value AS LastName, H.ItemDate AS BirthDate
   FROM Objects O
      INNER JOIN ObjType OT ON OT.Id = O.TypeId
      LEFT JOIN Strings S1 ON O.Id = S1.ObjectId
      LEFT JOIN StrDesc SD1 ON S1.TypeId = SD1.Id
      LEFT JOIN Strings S2 ON O.Id = S2.ObjectId
      LEFT JOIN StrDesc SD2 ON S2.TypeId = SD2.Id
      LEFT JOIN Strings S3 ON O.Id = S3.ObjectId
      LEFT JOIN StrDesc SD3 ON S3.TypeId = SD3.Id
      LEFT JOIN History H ON O.Id = H.ObjectId
      LEFT JOIN Status S ON H.TypeId = S.Id
   WHERE OT.Code = ‘PEOPLE’
      AND SD1.Code = ‘FAMILY’
      AND SD2.Code = ‘FIRSTNAME’
      AND SD3.Code = ‘LASTNAME’
      AND S.Code = ‘BIRTHDATE’