select  ;
t1.RatingMax	as t1MAX,;
t2.RatingMax	as t2MAX,;
t3.RatingMax	as t3MAX,;
NVL(T1.RatingMax,0) + NVL(T2.RatingMAX,0) + NVL(T3.RatingMAX,0) as SumMAXs, ;
NVL(T1.yyMMddhh, T2.yyMMddhh)  AS yyT2		,;
NVL(T1.yyMMddhh, T3.yyMMddhh)  AS yymmddhh	;
FROM T1	 ;
FULL JOIN  T2	;
FULL JOIN  T3	;
ON T1.yymmddhh = T2.yymmddhh;
ON T1.yymmddhh = T3.yymmddhh