专家坐堂-求助大神，这个多表统计要怎么写？Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

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") \'打开生成的统计表