SELECT user_je_source_name, je_source_name from gl_je_sources_tl union select description user_je_source_name, lookup_code je_source_name from igi_lookups where lookup_type ='IGI_CBR_JOURNAL_SOURCES'
View Text - HTML Formatted
SELECT USER_JE_SOURCE_NAME , JE_SOURCE_NAME FROM GL_JE_SOURCES_TL UNION SELECT DESCRIPTION USER_JE_SOURCE_NAME , LOOKUP_CODE JE_SOURCE_NAME FROM IGI_LOOKUPS WHERE LOOKUP_TYPE ='IGI_CBR_JOURNAL_SOURCES'