select a.dws_ukey from dws_auto_trade A with(nolock),dws_user B with(nolock) where a.dws_ukey=b.dws_ukey and b.dws_email = '' and a.trade_state = '1' and a.alram_check='0'