主题：如何实现类似物流明细的效果

可以，参考：

http://www.foxtable.com/help/topics/2321.htm

http://www.foxtable.com/help/topics/2322.htm

http://www.foxtable.com/help/topics/2314.htm

指定链接方式：

http://www.foxtable.com/help/topics/2330.htm

选择Inner(内连接)，这样双方都有的记录，才会出现在查询表。

测试通过：

Dim jb As new SQLJoinTableBuilder("流水查询","安装")
jb.addTable("安装","设备序列号","维修","设备序列号",JoinModeEnum.Left)
jb.addTable("安装","设备序列号","维护","设备序列号",JoinModeEnum.Left)
jb.addTable("安装","设备序列号","撤出","设备序列号",JoinModeEnum.Left)
jb.addcols("{安装}.设备序列号","{安装}.装机时间","{安装}.省份","{安装}.医院名称","{安装}.安装科室","维修日期","维修内容","维护日期","维护内容","撤出日期","{撤出}.备注")
jb.Build

Dim jb As new SQLJoinTableBuilder("流水查询","安装")
jb.addTable("安装","设备序列号","维修","设备序列号",JoinModeEnum.Left)
jb.addTable("安装","设备序列号","维护","设备序列号",JoinModeEnum.Left)
jb.addTable("安装","设备序列号","撤出","设备序列号",JoinModeEnum.Left)
jb.addcols("{安装}.设备序列号","{安装}.省份","{安装}.医院名称","{安装}.安装科室","维修内容","维护内容","{撤出}.备注")
jb.Addexp("日期_安装日期","装机时间")
jb.Addexp("日期_维护日期","维护日期")
jb.Addexp("日期_维修日期","维修日期")
jb.Addexp("日期_撤出日期","撤出日期")

jb.Build

前面误解你的意思， 4楼的效果：
 
Dim qy As new QueryBuilder()
qy.TableName = "流水查询"
qy.SelectString = "Select 装机时间 As 日期, '安装' as 类型,医院名称,安装科室,备注 From {安装} UNION select 维修日期 As 日期, '维修' as 类型,医院名称,安装科室,维修内容 AS 备注 From {维修} UNION select 维护日期 As 日期, '维护' as 类型,医院名称,安装科室,维护内容 AS 备注 From {维护} union  select 撤出日期 As 日期, '撤出' as 类型,医院名称,安装科室,备注 From {撤出}"
qy.Build()

 
测试通过。
 
有关知识参考:
http://www.foxtable.com/help/topics/0688.htm