dim sql as string = "select a.*,b.* from E1_scndx as a left join (select * from {E1_sccailiaodetail} where {E1_sccailiaodetail}.inputdate <='" & chaxunriqi & "' and {E1_sccailiaodetail}.sys_vchtype = '2-1' ) as b on a.某列 = b.某列"
Dim b As New GroupTableBuilder("单部位汇总",sql,"某数据源名称")