S elect a.emp_id,card_balance,OP_YMD From {MealRecords} a INNER JOIN (S elect emp_id,Max(sign_time) As sign_time From {MealRecords} where sign_time  <= #" & Vars("in_date") & "# Group By emp_id) b on a.emp_id = b.emp_id  And a.sign_time = b.sign_time"

请问这个SQL 语句，能用查询表的方式生成吗？

示例八【帮助文档的案例】

除Build方法外，SQLJoinTableBuilder还有一个BuildSQL方法，用于生成Select语句，例如在命令窗口执行：

Dim jb As New SQLJoinTableBuilder("查询表1","订单")
Dim sl As String
jb.ConnectionName = "Sale"
jb.AddTable("订单","产品ID","产品","产品ID")
jb.AddTable("订单", "客户ID","客户","客户ID")
jb.AddCols("产品名称","客户名称","日期", "数量","单价")
jb.AddExp("金额","数量 * 单价")
sl = jb.BuildSQL()
Output.Show(sl)

好的，谢谢袍哥！

辛苦您了！