主题：[求助] select 语句合并

你好，我有两个Se/lect语句，要把结果存于一个表中，该如何编写，如下合在一起出错了，谢谢。

Dim q  As new QueryBuilder
 q.TableName = "MPSDiff1"
q.Sel/ectString = "Se/lect {Orderlist}.OrderDate,{Orderlist}.批号,{Orderlist}.EndCustomer,{Orderlist}.CustomerPO,{Orderlist}.Pos,{Orderlist}.Part,{Orderlist}.PartNo,{Orderlist}.OrderQty,{Orderlist}.ETD,{myPlanningBackup}.OrderDate,{myPlanningBackup}.EndCustomer,{myPlanningBackup}.CustomerPO,{myPlanningBackup}.Pos,{myPlanningBackup}.Part,{myPlanningBackup}.PartNo,{myPlanningBackup}.OrderQty,{myPlanningBackup}.ETD From {Orderlist} Inner JOIN {myPlanningBackup} ON {myPlanningBackup}.[批号] = {Orderlist}.[批号] Where {Orderlist}.ETD <> {myPlanningBackup}.ETD" And q.Se/lectString = "Sel/ect {Orderlist}.OrderDate,{Orderlist}.批号,{Orderlist}.EndCustomer,{Orderlist}.CustomerPO,{Orderlist}.Pos,{Orderlist}.Part,{Orderlist}.PartNo,{Orderlist}.OrderQty,{Orderlist}.ETD,{myPlanningBackup}.OrderDate,{myPlanningBackup}.EndCustomer,{myPlanningBackup}.CustomerPO,{myPlanningBackup}.Pos,{myPlanningBackup}.Part,{myPlanningBackup}.PartNo,{myPlanningBackup}.OrderQty,{myPlanningBackup}.ETD,{myPlanningBackup}.批号 From {Orderlist} Left JOIN {myPlanningBackup} ON {myPlanningBackup}.[批号] = {Orderlist}.[批号] Where {myPlanningBackup}.批号 Is null"

q.Build
 MainTable = Tables("MPSDiff1")

谢谢回复。但是 我前面的se lect 和后面的 se lect 字段内容不一样的，不可以用union， 还有其它办法吗？