表1：《T+13.0》

更新日期：2022-05-29

select distinct dbname, iyear 
from (select dbname  from CO_JC_Account where dbtype like '用友T+%13.0%' and qiyong='是') as a
cross join (select distinct iyear  from TZ_JC_Fypeirod where iyear>=$(财务模块_数据同步年度范围) and iyear<=year(getdate())) as b

表2：《T+Cloud》

更新日期：2022-05-29

select distinct dbname, iyear 
from (select dbname  from CO_JC_Account where dbtype like '用友T+Cloud%' and qiyong='是') as a
cross join (select distinct iyear  from TZ_JC_Fypeirod where iyear>=$(财务模块_数据同步年度范围) and iyear<=year(getdate())) as b