-
dongy 小试身手Lv3
发表于2018-7-27 14:59
悬赏1
已解决
楼主
如下图sql所示,从不同的表取出的字段相同,所以做了相对应的名字对应。相应的sql语句在数据库工具中取出来的字段是正确的,但是在BI报表工具中显示的都是如图所示的S_VALUE这种形式。导致每个字段无法区分取出,所以来请教下大家,万分感谢
最佳答案
dongy 发表于 2018-7-30 15:42
企业版 V4.6.1R26-build20171220162840-r49735f0
辛苦
这个应该是个bug,我们核实后与您联系,还请谅解
13个回答
混乱七星天 发表于 2018-7-27 15:53
最外层select加别名了吗?sql贴全一点看看?
SELECT
t1.STHEONLYID
,t1.SSOCIALCRECODE
,t1.SORDERID
,t1.SACCOUNTID
,t1.SOLDACCOUNTID
,t1.SMEMBERCODE
,t1.SCERTTYPE
,SCERTNO
,t1.SGUARANTYSTYLE
,t1.SGUARANTNAME
,t1.DDATE
,t1.SACCOUNTNAME
,t1.SACCOUNTTYPE
,t1.SACCOUNTSOURCE
,t1.SORGNAME
,t1.ISURPLUSPERIOD
,t1.ISURPLUSAMOUNT
,t1.ISURPLUSLUCRE
,t1.SOLDREPAYMENTWAY
,t1.SASSETSUSE
,t1.SACCOUNTSTATE
,t1.SREPAYGUARANTWAY
,t1.ITRANSFERAMOUNT
,t1.ITRANSFERATE
,t1.IFEERATE
,t1.ITRANSFERFEE
,t1.DTRANSFERDATE
,t1.INV_PERSONNUM
,t1.SCURRENCY
,t2.SMEMBERTYPE
,t2.SMEMBERTYPE_name
,t2.SMEMBERCODE_INV
,t2.SWORKTYPE_INV
,t2.SWORKTYPE_INV_name
,t2.SAREA_INV
,t2.SAREA_INV_name
,t2.SINDUSTRYTYPE_INV
,t2.SINDUSTRYTYPE_INV_name
,t2.IAMOUNT
,t2.SSTATE
,t2.SSTATE_name
,t3.SAREACODE
,t3.SAREANAME
,t3.SORGANATION
,t3.SVALUE sorganname
,t4.S_VALUE SACCOUNTTYPE_name
,t5.S_VALUE SACCOUNTSOURCE_name
,t6.S_VALUE SACCOUNTSTATE_name
,t7.S_VALUE SOLDREPAYMENTWAY_name
,t8.S_VALUE SASSETSUSE_name
,t9.S_VALUE SREPAYGUARANTWAY_name
,t10.S_VALUE SCURRENCY_name
FROM nifa_business_jinr_s t1
LEFT JOIN (
SELECT
a.STHEONLYID
,a.DDATE
,a.SMEMBERTYPE
,t10.S_VALUE AS SMEMBERTYPE_name
,a.SMEMBERCODE_INV
,a.SWORKTYPE_INV
,t11.S_VALUE AS SWORKTYPE_INV_name
,a.SAREA_INV
,t14.SAREANAME AS SAREA_INV_name
,a.SINDUSTRYTYPE_INV
,t12.S_VALUE AS SINDUSTRYTYPE_INV_name
,a.IAMOUNT
,a.SSTATE
,t13.S_VALUE AS SSTATE_name
FROM nifa_business_jinr_inv_s a
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2547' )t10
ON a.SMEMBERTYPE = t10.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2517' )t11
ON a.SWORKTYPE_INV = t11.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2518' )t12
ON a.SINDUSTRYTYPE_INV = t12.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2548' )t13
ON a.SSTATE = t13.S_DISPLAYKEY
LEFT JOIN MAN_AREA_INFO t14
ON a.SAREA_INV = t14.SAREACODE) t2
ON t1.STHEONLYID=t2.STHEONLYID and t1.ddate=t2.ddate
LEFT JOIN (
SELECT a.SORGANATION,a.SVALUE,area.SAREACODE,area.SAREANAME FROM (
SELECT *
FROM NIFA_BUSINESS_A_INFO
WHERE iid IN (SELECT max(iid)
FROM NIFA_BUSINESS_A_INFO
WHERE SINDEXCODE = 'H31001'
GROUP BY SORGANATION) AND SINDEXCODE = 'H31001')a
LEFT JOIN MAN_AREA_INFO area
ON a.SAREACODE = area.SAREACODE
)t3
ON t1.SSOCIALCRECODE = t3.SORGANATION
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2544' )t4
ON t1.SACCOUNTTYPE = t4.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2545' )t5
ON t1.SACCOUNTSOURCE = t5.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2543' )t6
ON t1.SACCOUNTSTATE = t6.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2013' )t7
ON t1.SOLDREPAYMENTWAY = t7.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2014' )t8
ON t1.SASSETSUSE = t8.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2550' )t9
ON t1.SREPAYGUARANTWAY = t9.S_DISPLAYKEY
LEFT JOIN (
SELECT S_VALUE,S_DISPLAYKEY FROM UB_DICTIONARY WHERE S_TYPE = '2542' )t10
ON t1.SCURRENCY = t10.S_DISPLAYKEY
WHERE 1=1
我试着加过一个as 没生效 我都加上试试