CREATE TABLE temp_map9 AS
SELECT
vqm.vqm_qot_id ,fsdq.fsdq_sup_xpressfeed, fsdq.fsdq_tickersymbol, fsdq.fsdq_isin, vsdq.vsdq_ticker_symbol1, vsdq.vsdq_on, vsdq.vsdq_ic, vsdq.vsdq_ticker_symbol2, vem.vem_vexc_shortname
FROM
vsdq,
fsdq,
vem,
vqm
WHERE
1=1

AND vqm.vqm_qot_sup_xpressfeed = fsdq.fsdq_sup_xpressfeed
AND vsdq.vsdq_vexc_id = vem.vem_vexc_shortname
AND fsdq.fsdq_fsb_id = vem.vem_fsb_id
AND (vsdq.vsdq_ticker_symbol1 = fsdq.fsdq_tickersymbol
OR
vsdq.vsdq_ticker_symbol2 = fsdq.fsdq_tickersymbol
--or
--vsdq.vsdq_on = fsdq.fsdq_tickersymbol ||'.'|| vsdq.vsdq_vexc_id
)

;