业务表只存ID ，名称是通过关联查找出来，查询模块有些...

lbx888

fengwei

你的查询语句是怎么写的

lbx888

做关联

lbx888

select oa_FinanceMaster.*,a.sName as FCreateDeptName,b.sName as FCreatePosName,c.sName as FCreatePerName,d.sName as FMBPersonName,e.sName as FMBDeptName,f.fName as FdutyName,g.fName as FBizOrginName,h.fName as FPayForTypeName,j.fName as FPayKindName
    from oa_FinanceMaster oa_FinanceMaster
     optional  join V_SA_OPOrg a on oa_FinanceMaster.FCREATEDEPTID = a AND a.sOrgKindID = 'dpt'
     optional  join V_SA_OPOrg b on oa_FinanceMaster.FCREATEPOSID = b AND b.sOrgKindID = 'dpt'
     optional  join V_SA_OPPerson c on oa_FinanceMaster.FCREATEPERID = c
     optional  join V_SA_OPPerson d on oa_FinanceMaster.FMBPerson = d
     optional  join V_SA_OPOrg e on oa_FinanceMaster.FMBDept = e AND e.sOrgKindID = 'dpt'
     optional  join OA_Pub_BaseCode f on oa_FinanceMaster.FDuty = f.fCode AND f.fScope = '员工职务'
     optional  join OA_Pub_BaseCode g on oa_FinanceMaster.FBIZORIGN = g.fCode AND g.fScope = '单据所属公司'
     optional  join OA_Pub_BaseCode h on oa_FinanceMaster.FTYPE = h AND h.fScope = '付款类型'
     optional  join OA_Pub_BaseCode j on oa_FinanceMaster.FPAYKIND = j AND j.fScope = '付款方式'

fengwei

lbx888 发表于 2013-12-26 16:10
做关联

关联的时候没有定义别名吗？

lbx888

action KSQL

XiaoQLuo

抱歉目前这样用法还没有提供名称定义方式