Dim cmd1 As New SQLCommand
cmd1.C
cmd1.CommandText ="(S elect [FPrintNo] from {SHProcRptMain} where [FBillNo]=(S elect [FSourceBillNo] from {vwICBill_2} where FBatchNo = '" & dr("批号") & "'))"
Dim T1 As New QueryBuilder
T1.TableName = "T1"
T1.S electString = cmd1.CommandText
T1.Build
'Dim cmd2 As New SQLCommand
'cmd2.C
'cmd2.CommandText ="(S elect 数据 from 电容出厂 where 客户料号=tbl.Current("客户对应物料代码") And 打印标记=cmd1)"
老师,2个数据库的内容如何连起来查询?另子查询查出来的结果是数组不唯一,如何处理最后得出惟一值?
S elect 数据 from 电容出厂 where 客户料号=tbl.Current("客户对应物料代码") And 打印标记=(S elect [FPrintNo] from {SHProcRptMain} where [FBillNo]=(S elect [FSourceBillNo] from {vwICBill_2} where FBatchNo = '" & dr("批号") & "'))
[此贴子已经被作者于2017/9/23 17:55:45编辑过]