blob: 4708b12590c3cecece00cd842ec671ac5a0f7dc0 [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.d28 = j2.d28)
LEFT OUTER JOIN j3 ON
(j1.d28 = j3.d28)
LEFT OUTER JOIN j4 ON
(j1.d28 = j4.d28)
where
j1.d28 IS NOT NULL
and LOWER(COALESCE(j1.c_varchar || j2.c_varchar || j3.c_varchar || j4.c_varchar, 'EMPTY')) <> 'empty'
;