SELECT s.je_source_name, s.user_je_source_name description FROM gl_je_sources s UNION SELECT l.lookup_code, l.meaning FROM gl_lookups l WHERE l.lookup_type = 'LITERAL' AND l.lookup_code = 'ALL'
View Text - HTML Formatted
SELECT S.JE_SOURCE_NAME , S.USER_JE_SOURCE_NAME DESCRIPTION FROM GL_JE_SOURCES S UNION SELECT L.LOOKUP_CODE , L.MEANING FROM GL_LOOKUPS L WHERE L.LOOKUP_TYPE = 'LITERAL' AND L.LOOKUP_CODE = 'ALL'