多表合并数据 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim dt1 As DataTable = DataTables("汇总")
Dim dt2 As DataTable = DataTables("手术室")
Dim dt3 As DataTable = DataTables("外科")
For Each dr1 As DataRow In dt2.Select("")
    Dim dr2 As DataRow = dt1.Find("编码 = '" & dr1("编码") & "'")
    If dr2 Is Nothing Then dr2 = dt1.addnew
    For Each dc As DataCol In dt2.DataCols
        dr2(dc.Name) = dr1(dc.name)
    Next
    dr2("数量") = dt2.Compute("sum(数量)", "编码 = '" & dr1("编码") & "'") + dt3.Compute("sum(数量)", "编码 = '" & dr1("编码") & "'")
Next
For Each dr1 As DataRow In dt3.Select("")
    Dim dr2 As DataRow = dt1.Find("编码 = '" & dr1("编码") & "'")
    If dr2 Is Nothing Then dr2 = dt1.addnew
    For Each dc As DataCol In dt2.DataCols
        dr2(dc.Name) = dr1(dc.name)
    Next
    dr2("数量") = dt2.Compute("sum(数量)", "编码 = '" & dr1("编码") & "'") + dt3.Compute("sum(数量)", "编码 = '" & dr1("编码") & "'")
Next

主题：多表合并数据