-
-
17600051354 初学数据Lv2
发表于2018-9-27 17:21
悬赏1
已解决
最近看过此主题的会员
11个回答
-
17600051354 初学数据Lv2
select SAREANAME , ddate,SAREACODE,SORGANATION,sorganname,money1,money16,money19,money21,money22,SMEMBERCODE FROM (
SELECT
area.SAREANAME AS sareaname
,f0.*
,fa.SVALUE as sorganname
,fs.svalue AS SMEMBERCODE
,f1.favlue as money1
,f15.favlue as money16
,f18.favlue as money19
,f20.favlue as money21
,f21.favlue as money22
FROM
(SELECT ddate, SAREACODE,SORGANATION FROM NIFA_BUSINESS_B_INFO t1 WHERE t1.ISHEETID = 23 GROUP BY ddate,SAREACODE, SORGANATION ) f0
LEFT JOIN (SELECT t1.* FROM NIFA_BUSINESS_B_INFO t1 WHERE t1.SINDEXCODE='H23001' ) f1
ON f0.ddate=f1.ddate
AND f0.SORGANATION=f1.SORGANATION
LEFT join (SELECT t1.* FROM NIFA_BUSINESS_B_INFO t1 WHERE t1.SINDEXCODE='H23016' ) f15
ON f0.ddate=f15.ddate
AND f0.SORGANATION=f15.SORGANATION
LEFT join (SELECT t1.* FROM NIFA_BUSINESS_B_INFO t1 WHERE t1.SINDEXCODE='H23019' ) f18
ON f0.ddate=f18.ddate
AND f0.SORGANATION=f18.SORGANATION
LEFT join (SELECT t1.* FROM NIFA_BUSINESS_B_INFO t1 WHERE t1.SINDEXCODE='H23021' ) f20
ON f0.ddate=f20.ddate
AND f0.SORGANATION=f20.SORGANATION
LEFT join (SELECT t1.* FROM NIFA_BUSINESS_B_INFO t1 WHERE t1.SINDEXCODE='H23022' ) f21
ON f0.ddate=f21.ddate
AND f0.SORGANATION=f21.SORGANATION
LEFT JOIN MAN_AREA_INFO area
ON f0.SAREACODE = area.SAREACODE
LEFT JOIN (select a.SORGANATION,a.ddate,b.SVALUE from (select SORGANATION,max(DDATE) DDATE from NIFA_BUSINESS_A_INFO where isheetid='44' group by SORGANATION) a
left join NIFA_BUSINESS_A_INFO b ON a.SORGANATION=b.SORGANATION and a.DDATE=b.DDATE and b.SINDEXCODE='H21001'
) fa
ON f0.SORGANATION=fa.SORGANATION
LEFT join (SELECT t1.svalue,t1.DDATE,t1.SORGANATION FROM NIFA_BUSINESS_A_INFO t1 WHERE isheetid = 44 and t1.SINDEXCODE='H21004' ) fs
ON fa.ddate=fs.ddate
AND fa.SORGANATION=fs.SORGANATION
)ff
WHERE 1=1
AND 1=1
AND 1=1
AND 1=1
AND 1=1
ORDER BY ddate
-
17600051354 初学数据Lv2
sql是能执行成功的,数据库管理工具里面查出来就能排序，在Bi展示的时候就排不了序
17600051354 发表于 2018-9-27 17:30
sql是能执行成功的,数据库管理工具里面查出来就能排序，在Bi展示的时候就排不了序 ...
sql数据源如果有排序，在BI中也是按照其排序的呢。您的BI版本是多少？
