主题：生成表

错误

完整代码，或者sql

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:多表合表.foxdb

标识和编号有什么关系？比如A2对应2个编号，这2个编号都取还是只取流水号最大的编号？

标识针对某一个部门，编号针对的是一个单位

取流水号最大的编号

select c.编号,A,B,c,d,e,f from ({表1} as c inner join (select 编号,c,d from {表2} as a1 inner join (select 标识,max(流水号) as 流水号 from {表2}  group by 标识)  as a2 on a1.标识=a2.标识 where a1.流水号 = a2.流水号) as b on c.编号=b.编号) inner join (select b1.编号,e,f from {表3} as b1 inner join (select 编号,max(序号2) as 序号2 from {表3}  group by 编号)  as b2 on b1.编号=b2.编号 where b1.序号2 = b2.序号2) as d on c.编号=d.编号