>You are right. Much more importantly, how do I expand the FULL JOIN to include more than 2 tables?
>Or, should I just do 2 tables at a time. First join T1 and T2.
>Then take the result and join it with T3, etc? Thank you, Steve
>
>

>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, T3.yyMMddhh)  AS yyMMddhh	;
>FROM;
>T1	 ;
>FULL JOIN  ;
>T2	;  &&& how do I add in T3 and T4, etc.
>ON T1.yymmddhh = T2.yymmddhh = T3.yymmddhh
>

Steve,

How about you take a short break and visit the website I gave you yesterday or any other website and educate yourself a bit on how SQL language works? SQL language is quite simple, it will take 2 hours at most to learn the basics.