主题：关于SQL使用的问题

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.编号

参考：http://www.foxtable.com/webhelp/topics/2912.htm

老师，2个文本框的启止日期做为条件，实现三个表合并？谢谢

日期和三个表有什么关系？