ID_, ALIAS_, DATASOURCES_TYPE_, CREATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_ORG_ID_, UPDATE_TIME_, TENANT_ID_ select t.*,t1.DATASOURCES_TYPE_ from portal_sys_datasource t right join biz_datasources_relation t1 on t.alias_=t1.ALIAS_ where 1=1 and t1.datasources_type_=#{datasourcesType}