我不擅长sql 语句,今天学习到了从两个表中将外键和id一致,且字段version是最大的数据拼接到一起
select * from (SELECT * FROM sysstructure) as T1
join (SELECT * From sysweight) as T2
on T1.id=T2.PK_sysStructureID
AND T2.version=(select MAX(version) from sysweight)
weka是通过sql调用数据封装成Instances,用这种拼接方式的变化,可以凭借出我想要的其他数据