| 以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- 关于组合表两个表里面都有同一名称的属性列 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=80810) |
| -- 作者：sara -- 发布时间：2016/2/2 13:40:00 -- 关于组合表两个表里面都有同一名称的属性列 关于组合表两个表里面都有同一名称的属性列，那我该怎么写属性呢？Dim jb1 As New SQLJoinTableBuilder("销售订单客户表","MF_POS") jb1.C jb1.AddTable("MF_POS","CUS_NO","CUST","CUS_NO") jb1.AddCols("OS_ID","OS_NO","OS_DD","NAME", "SAL_NO","CLS_ID","RK_CLS_ID","VALID_ID","HIS_PRICE","PRE_ID","CLS_MP_ID","INV_DIS_ID","PAY_DD") jb1.Filter= "OS_ID = \'SO\' And SAL_NO = \'"& _SalNo &"\'" Tables("销售速查窗口_Table1").Fill(jb1.BuildSql,"DB_1",True)其中PAY_DD在两个表中都有，我想调用MF_POS中的
|
| -- 作者：大红袍 -- 发布时间：2016/2/2 14:41:00 --
jb1.AddCols("OS_ID","OS_NO","OS_DD","NAME", "SAL_NO","CLS_ID","RK_CLS_ID","VALID_ID","HIS_PRICE","PRE_ID","CLS_MP_ID","INV_DIS_ID","{MF_POS}.PAY_DD") |