framework/resources/Functional/joins/right_outer/4way_on_d38.sql.drill-2411

select 
		j1.c_integer,
		j2.c_integer,
		SUM(
			CASE 	WHEN j1.c_integer IS NULL THEN 0 
				WHEN j1.c_integer >= 0 THEN j2.c_integer*1.2 + 100
				WHEN j1.c_integer < 0 THEN -1
			END
		   )
from
        j2 RIGHT OUTER JOIN j1 ON
        (j1.d38 = j2.d38)
	   RIGHT OUTER JOIN j3 ON
	(j1.d38 = j3.d38)
	   RIGHT OUTER JOIN j4 ON
	(j1.d38 = j4.d38)
where
	j1.d38 IS NOT NULL
group by
	j1.c_integer,
	j2.c_integer
;


select *
from
        j2 RIGHT OUTER JOIN j1 ON
        (j1.d38 = j2.d38)
           RIGHT OUTER JOIN j3 ON
        (j1.d38 = j3.d38)
           RIGHT OUTER JOIN j4 ON
        (j1.d38 = j4.d38)
where
        j1.d38 IS NOT NULL
;