遇上同名列的时候,记得要指定来源表,例如下面的产品ID列:
Dim jb As New SQLJoinTableBuilder("查询表1","表B")
jb.ConnectionName = "Sale"
jb.AddTable("表B","单号","表A","单号")
jb.AddCols("{表B}.单号","{表B}.产品ID", "{表B}.品名", "{表B}.规格","{表B}.单位", "{表B}.数量","{表B}.日期")
jb.Build()
MainTable = Tables("查询表1")
表B的字段:单号、产品ID、品名、规格、单位、数量、日期
表A的字段:单号、产品ID、品名、规格、单位、数量、日期
如何实现下面:
合并表的字段:单号、产品ID、品名、规格、单位、来料数量、来料日期、检测日期、检测数量