以文本方式查看主题 -  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp) --  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2) ----  SQLJoinTableBuilder如何将列重命名  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=173097)

--  作者：guosheng --  发布时间：2021/11/15 14:33:00 --  SQLJoinTableBuilder如何将列重命名 在不改变“列”所在位置（即：在查询表1的第4列）的前提下，如何将“invoice_code”重命名为“发票代码”？ Dim jb As New SQLJoinTableBuilder("查询表1","租赁合同发票明细表") jb.C jb.AddTable("租赁合同发票明细表","合同编号","租赁合同结转情况表","合同编号",JoinModeEnum.Left) jb.AddCols("服务名称","不含税金额","含税金额","invoice_code","invoice_num",……) jb.filter= filter jb.Build()

--  作者：有点蓝 --  发布时间：2021/11/15 14:40:00 --   http://www.foxtable.com/webhelp/topics/2314.htm jb.AddTable("租赁合同fa piao明细表","合同编号","租赁合同结转情况表","合同编号",JoinModeEnum.Left) jb.AddCols("服务名称","不含税金额","含税金额","invoice_num",……) jb.AddExp("fa piao代码","invoice_code") jb.filter= filter jb.Build()