SELECT to_char(q.quota_id) quota_id, q.name name from cn_quotas q UNION SELECT lookup_code, meaning from cn_lookups where lookup_type = 'ELEMENT_TYPE'
View Text - HTML Formatted
SELECT TO_CHAR(Q.QUOTA_ID) QUOTA_ID , Q.NAME NAME FROM CN_QUOTAS Q UNION SELECT LOOKUP_CODE , MEANING FROM CN_LOOKUPS WHERE LOOKUP_TYPE = 'ELEMENT_TYPE'