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)
[此贴子已经被作者于2016/3/8 0:44:11编辑过]