主题：求助大神，这个多表统计要怎么写？

Dim b As New SQLGroupTableBuilder("统计表1", "用户表")

b.   C

b.AddTable( "用户表", "SysId", "出勤晚到表", "SysParentId", JoinModeEnum.Left) '添加统计表《===

b.AddTable("用户表", "SysId", "订房表", "SysParentId", JoinModeEnum.Left) '添加统计表

b.Groups.AddDef("{用户表}.SysId") '

b.Groups.AddDef("{用户表}.昵称") '

b.Groups.AddDef("{用户表}.角色") '

b.Groups.AddDef("{用户表}.组别") '

b.Totals.Addexp("出勤数", "Case When {出勤晚到表}.类型='出勤' And {出勤晚到表}.日期>='2024-10-01' And {出勤晚到表}.日期<='2024-10-04' Then 1 Else 0 End") '对数量进行统计

b.Totals.Addexp("饭局数", "Case When {出勤晚到表}.备注='饭局晚到' And {出勤晚到表}.日期>='2024-10-01' And {出勤晚到表}.日期<='2024-10-04' Then 1 Else 0 End") '对数量进行统计

b.Totals.Addexp("订房数", "Case When {订房表}.日期>='2024-10-01' And {订房表}.日期<='2024-10-04' Then 1 Else 0 End")

b.Filter = "{出勤晚到表}.组别='A' And {用户表}.状态<>'离职'"

b.Build '生成统计表

Maintable = Tables("统计表1") '打开生成的统计表