framework/resources/Functional/joins/full_outer/4way_on_c_date.sql

select
               SUM(
                   CASE    WHEN j2.c_integer IS NULL THEN 0
                           WHEN j2.c_integer >= 0 THEN j2.c_integer*1.2 + 100
                           WHEN j2.c_integer < 0 THEN j2.c_integer
                   END
                   )
from
        j2 FULL OUTER JOIN j1 ON
        (j1.c_date = j2.c_date)
           FULL OUTER JOIN j3 ON
        (j1.c_date = j3.c_date)
           FULL OUTER JOIN j4 ON
        (j1.c_date = j4.c_date)
where
        j1.c_date IS NOT NULL
;