就两个表而已,你转换为内部数据表,不就方便大家吗?
否则大家回答你的问题,还得找的安装SQL Server的电脑,还得附加你提通的数据库。
当然就没有什么人愿意回答了。
Dim jb As New SQLJoinTableBuilder("查询表","种鸡生产记录")
jb.Connection Name = "zjxt"
Dim Cols1() As String = {"品种","周龄"}
Dim Cols2() As String = {"品种","周龄"}
jb.AddTable("种鸡生产记录",Cols1,"饲养标准",Cols2)
jb.AddCols("{种鸡生产记录}.品种","{种鸡生产记录}.周龄","标准产蛋率")
jb.AddExp("实际产蛋率", "(IsNull([合格蛋数],0) + IsNull([次蛋数],0) + IsNull([破蛋数],0))/[存栏母鸡]")
jb.Filter = "批次 = '20090710'"
jb.Build
[此贴子已经被作者于2011-12-28 9:53:57编辑过]