SELECT
fsdq.fsdq_sup_xpressfeed AS sup, fsdq.fsdq_tickersymbol, fsdq.fsdq_isin, vsdq.vsdq_ticker_symbol1, vsdq.vsdq_on, vsdq.vsdq_ic, vsdq.vsdq_ticker_symbol2--, vqm.vqm_qot_id --, vem.vem_vexc_shortname
FROM
vsdq,
fsdq,
vem,
vqm
WHERE
1=1
AND REPLACE(vqm.vqm_qot_sup_xpressfeed,'M') = fsdq.fsdq_sup_xpressfeed
AND vsdq.vsdq_vexc_id = vem.vem_vexc_shortname
AND fsdq.fsdq_fsb_id = vem.vem_fsb_id --= fsdq.fsdq_sup_xpressfeed
AND
(
     vsdq.vsdq_on = fsdq_tickersymbol|| '.' ||vsdq.vsdq_vexc_id
     OR
    vsdq.vsdq_ticker_symbol1 = fsdq.fsdq_tickersymbol
     OR
     vsdq.vsdq_ticker_symbol2 = fsdq.fsdq_tickersymbol
     OR
     vsdq.vsdq_ic = fsdq.fsdq_tickersymbol
   )