请指导我如何在Microstratergy.中实现以下查询
选择batch_nr,check_nr,update_ts从claim_financial_transaction_dim a,(选择max(update_ts) update_ts,check_nr,batch_nr从claim_financial_transaction_dim组通过check_nr)最大,其中ROW_END_TS IN ('9999-12-31 00:00:00')和a.check_nr IN ('045-4254355')和a.update_ts=max.update_ts和a