SELECT Individual.Uid
      ,Individual.Name
      ,Individual.CreationDate
      ,Individual.CreationAuthor
      ,Individual.ChangeDate
      ,Individual.ChangeAuthor
      ,Individual.LastName
      ,Individual.FirstName
      ,Individual.MiddleName
      ,Individual.BirthDate
      ,Individual.Series
      ,Individual.Number
      ,Individual.DateIssue
      ,Individual.Department
      ,Individual.DepartmentCode
      ,Individual.INN
      ,Individual.SNILS
      ,Individual.Residence
      ,Individual.Seat
      ,Individual.Postal
      ,Individual.Phone
      ,Individual.Email
      ,Individual.BirthPlacePassport
      ,Individual.IssuedCity
      ,Individual.Id
  FROM Individual

  WHERE Individual.Id in (Select SubjectShare.Individual from SubjectShare WHERE SubjectShare.[Subject]=10666)