Dim jb As New SQLJoinTableBuilder("流向查询表","客户表") Dim Cols1() As String ={"品名","规格","医疗机构"} Dim Cols2() As String ={"品名","规格","医疗机构"} jb.Addtable("客户表",Cols1,"流向表",cols2) jb.AddCols("所属区域","医院等级","客户","联系方式","开piao时间","{客户表}.医疗机构","{客户表}.品种","{客户表}.规格","单价","数量") jb.AddExp("金额","数量*单价")