Left Join Issue

create table T (sid1 int,sub char(2))
insert into t(Sid1,sub)
values 
(201 ,'T1'),(201 ,'T2'),(201,'T5'),
(202 ,'T2'),(202 , 'T3'),(203 , 'T4')

create table T2 (sub char(2))
insert into t2(sub)
values ('T1'),('T2'),( 'T3'),('T4'),('T5')


create function fncT2 (@SID int)
RETURNS TABLE 
AS
RETURN 
(select T2.Sub,T.Sid1 from T2 left outer join T on T2.Sub=T.Sub and T.Sid1=@sid)

;with Temp as
(select  distinct T.sid1 from T)
select B.* from Temp cross apply fncT2(sid1 ) B

---

Hope it Helps!!