主题：生成表

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

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

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

刷新一下：http://www.foxtable.com/webhelp/topics/0115.htm

把表达式替换sql里面的序号列名称

一样的用法，改不同列即可

完整代码，或者sql

标识和编号有什么关系？比如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.编号