主题：关于多表查询和

1、可以判断，如果为空，就设置成0

如 jb.AddExp("金额","isnull(数量,0) * isnull(单价,0)")

或者  jb.AddExp("金额","iif(数量 is null,0, 数量) * iif(单价 is null,0,单价)")

2、不可能一直卡的，卡也是你运行代码的时候才会卡，你一直运行么？

Dim b As New SQLGroupTableBuilder("统计表1","海报清单表")
b.AddTable("海报清单表","海报档期号","海报档期基本信息表","海报档期号")
b.Groups.AddDef("{海报清单表}.海报档期号","海报档期号")
b.Groups.AddDef("{海报档期基本信息表}.海报主题","海报主题")
b.Totals.AddExp("销售额","销售额 / 10000")
Dim dt1 As fxDataSource
dt1 = b.BuildDataSource()

b = New SQLGroupTableBuilder("统计表2","海报预估销售表")
b.AddTable("海报预估销售表","海报档期号","海报档期基本信息表","海报档期号")
b.Groups.AddDef("{海报预估销售表}.海报档期号","海报档期号")
b.Groups.AddDef("{海报档期基本信息表}.海报主题","海报主题")
b.Totals.AddExp("目标销售","目标销售")
Dim dt2 As fxDataSource
dt2 = b.BuildDataSource()

dt1.Combine("海报档期号",dt2,"海报档期号")

dt1.show("测试")
MainTable = Tables("测试")