看看奇怪的问题 SELECT indexcd as 指数代码, idxinfo01 as 指数名称, chgsmp02 as 证券代码,chgsmp03 as 证券名称, chgsmp03_en as 证券英文名称, idxinfo01_en as 指数英文名称
FROM (SELECT *
FROM 交易所指数
WHERE not exists (select F1 , F3
FROM T_shcfg_end where f1=交易所指数.indexcd and f3=交易所指数.chgsmp02)) DERIVEDTBL
WHERE (Indexcd IN
(SELECT F1
FROM T_shcfg_end)) AND (Indexcd NOT IN (select indexcd from 中证不需要每天对比的指数汇总)) and indexcd like 'h110%'
ORDER BY Index