blob: 326042f7ce23efd8ad9e4411f8622e0fccdcd813 [file] [log] [blame]
select DISTINCT
COALESCE(j1.c_varchar || j2.c_varchar || j3.c_varchar || j4.c_varchar, 'EMPTY') as concatentated_string
from
j1 LEFT OUTER JOIN j2 ON
(j1.c_date = j2.c_date)
LEFT OUTER JOIN j3 ON
(j1.c_date = j3.c_date)
LEFT OUTER JOIN j4 ON
(j1.c_date = j4.c_date)
where
j1.c_date IS NOT NULL
and LOWER(COALESCE(j1.c_varchar || j2.c_varchar || j3.c_varchar || j4.c_varchar, 'EMPTY')) <> 'empty'
;