How do I do a Cross Join when I don't have all the columns I need?, Sql Server

Language: Layout:

create table t ([SITA] varchar(5), [B] varchar(2), [C] varchar(2), [Rooms] int, [Datearrived] varchar(10), [Market_segment] varchar(3), [RN] int, [Rev] int) ;
insert into t ([SITA], [B], [C], [Rooms], [Datearrived], [Market_segment], [RN], [Rev]) values
 ('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'TOF', 2, 45)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'BAO', 33, 30.5)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'BGR', 11, 50)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'NRG', 52, 10)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'CRW', 20, 90)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'BIT', 7, 20)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'CBI', 0, 40)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'OTH', 10, 50)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'BIQ', 11, 60)
,('ABZPD', 'PI', 'GB', 150, '2017-01-01', 'RER', 12, 65)
;
create table Segmentation ([SEG] varchar(3)) ; 
insert into Segmentation ([SEG]) values 
('RAC'), ('BIT'), ('BIQ'), ('CBI'), ('TOF'), ('QOF'), ('BOA'), ('FIT'), ('LYO'), ('RER'), ('OTH'), ('NRG'), ('XXX'), ('CRW'), ('BGR'), ('BGO'), ('LGR'), ('LGS');

select 
    d.SITA
  , d.B
  , d.C
  , d.Rooms
  , d.Datearrived
  , Market_segment = s.Seg
  , Rn  = isnull(t.rn,0)
  , Rev = isnull(t.Rev,0)
from (
  select distinct sita, B, C, Rooms, datearrived 
  from dbo.t -- whichever table has the above columns
  ) d
cross join (
  select SEG
  from dbo.Segmentation
  where SEG in ('RAC', 'BIT', 'BIQ', 'CBI', 'TOF', 'QOF', 'BOA', 'FIT', 'LYO', 'RER', 'OTH', 'NRG', 'XXX', 'CRW', 'BGR', 'BGO', 'LGR', 'LGS') 
  ) s
left join dbo.t 
  on d.datearrived = t.datearrived
 and d.sita = t.sita
 and s.seg = t.market_segment

View schema
Execution time: 0,05 sec, rows selected: 18, rows affected: 28, absolute service time: 0,19 sec