Is it possible to join a SELECT from one table with another SELECT from other table in a single row?, Sql Server

Language: Layout:

set dateformat dmy;
create table Studies ([CodeStudent] int, [TypeStudy] varchar(13), [TitleStudy] varchar(10), [DateStudy] date, [PlaceStudy] varchar(11)) ; 
insert into Studies ([CodeStudent], [TypeStudy], [TitleStudy], [DateStudy], [PlaceStudy]) values 
 (10, 'Technical', 'TitleOne', '2005-01-02', 'Narnia')
,(10, 'Technological', 'TitleTwo', '2009-01-05', 'Mars')
,(10, 'University', 'TitleThree', '2012-01-08', 'Gotham City')
,(20, 'Technical', 'OtherTitle', '2011-01-06', 'Namek');
create table Student ([CodeStudent] int, [Name] varchar(3), [LastName] varchar(7), [BirthDate] datetime);
insert into Student ([CodeStudent], [Name], [LastName], [BirthDate]) values
 (10, 'Hug', 'Lobezno', '2002-02-02')
,(20, 'Son', 'Gokú', '2007-05-06');

select
    S.CodeStudent
  , S.Name
  , S.LastName
  , S.BirthDate
  , TitleTechnical     = max(case when t.TypeStudy = 'Technical' then t.TitleStudy end)
  , DateTechnical      = max(case when t.TypeStudy = 'Technical' then t.DateStudy end)
  , PlaceTechnical     = max(case when t.TypeStudy = 'Technical' then t.PlaceStudy end)
  , TitleTechnological = max(case when t.TypeStudy = 'Technological' then t.TitleStudy end)
  , DateTechnological  = max(case when t.TypeStudy = 'Technological' then t.DateStudy end)
  , PlaceTechnological = max(case when t.TypeStudy = 'Technological' then t.PlaceStudy end)
  , TitleUniversity    = max(case when t.TypeStudy = 'University' then t.TitleStudy end)
  , DateUniversity     = max(case when t.TypeStudy = 'University' then t.DateStudy end)
  , PlaceUniversity    = max(case when t.TypeStudy = 'University' then t.PlaceStudy end)
from Student S
  left join Studies T  -- left join to support querying students with no studies
    on s.CodeStudent = t.CodeStudent
where S.CodeStudent = 10
group by 
    S.CodeStudent
  , S.Name
  , S.LastName
  , S.BirthDate

View schema
Execution time: 0,03 sec, rows selected: 1, rows affected: 6, absolute service time: 0,17 sec

Is it possible to join a SELECT from one table with another SELECT fro...