blob: 64a65d118c754fc208ba219fa8c771145fcbd962 [file] [log] [blame]
select
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.c_float = j2.c_float)
RIGHT OUTER JOIN j3 ON
(j1.c_float = j3.c_float)
RIGHT OUTER JOIN j4 ON
(j1.c_float = j4.c_float)
where
j1.c_float IS NOT NULL
;