SELECT distinct s.user_je_source_name, c.request_id, c.group_id, c.set_of_books_id from gl_interface c, gl_je_sources s WHERE s.user_je_source_name = c.user_je_source_name and c.request_id is not null
View Text - HTML Formatted
SELECT DISTINCT S.USER_JE_SOURCE_NAME , C.REQUEST_ID , C.GROUP_ID , C.SET_OF_BOOKS_ID FROM GL_INTERFACE C , GL_JE_SOURCES S WHERE S.USER_JE_SOURCE_NAME = C.USER_JE_SOURCE_NAME AND C.REQUEST_ID IS NOT NULL