>>>>NVL(T1.RatingSum,0) + NVL(T2.RatingSum) as TotalRating,; && too few arguments >>>>>>>
>>select ; >>NVL(T1.RatingSum,0) + NVL(T2.RatingSum,0) as TotalRating, ; >>NVL(T1.mDate, T2.mDate) AS yyMMddhh ; >>FROM ; >>( select ; >>MAX(mRating) as RatingSUM ,; &&&&&&&& "syntax error" ??? >>substr(CAST(mIndex as C(14)),1,6) as mDate ; >>from tab1 ; >>GROUP BY 2 >>) AS T1 ; >>FULL JOIN ; >>(select ; >>MAX(mRating) as RatingSUM ,; >>substr(CAST(mIndex as C(14)),1,6) as mDate ; >>from tab2 ; >>GROUP BY 2 >>) ; >>T2 ; >>ON T1.mDate = T2.mDate >>>
select ; NVL(T1.RatingMax,0) + NVL(T2.RatingMAX,0) as SumMAXs, ; NVL(T1.yyMMddhh, T2.yyMMddhh) AS yyMMddhh ; && corrected? The top select needs yyMMddhh, from Tab1 and Tab2 FROM ; ( ; select ; && this select works fine MAX(mRating) as RatingMAX ,; && still get syntax error here -- still same substr(CAST(mIndex as C(14)),1,6) as yyMMddhh ; from t1 ; GROUP BY 2 ) ; T1 ; FULL JOIN ; ( ; select ; && this select works fine MAX(mRating) as RatingMAX ,; substr(CAST(mIndex as C(14)),1,6) as yyMMddhh ; from t2 ; GROUP BY 2 ) ; T2 ; ON T1.yymmddhh = T2.yymmddhh