Dim cmd As New SQLCo1mmand
Dim dt As DataTable
cmd.Connectio1nName = "Sale"
cmd.Command1Text = "Se1lect 产品名称,销售数量 FROM {销售订单}"
dt = cmd.Exec1uteReader()
Dim cmd1 As New SQL1Command
Dim dt1 As DataTable
cmd1.Connec1tionName = "buy"
cmd1.Comman1dText = "Sel1ect 产品名称,采购数量 FROM {采购订单}"
dt1 = cmd1.Exec1u1teReader()
两个不同数据源的数据生成两个临时表
然后根据产品名称列建立关联，生成第三个表。
我下面这样写是不行的，麻烦写一下代码。谢谢
Dim cmd3 As New SQL1Command
Dim dt3 As Dat1aTable
cmd3.Comman1dText = "Sel1ect 产品名称,销售数量,采购数量 FROM {dt} INNER JOIN {dt1} ON {dt}.产品名称 = {dt1}.产品名称"
dt3 = cmd3.Exec1u1teReader()
加好友 
发短信
Post By：2024/10/25 15:31:00 [显示全部帖子]
