SELECT
o. ID AS ID,
( CASE
WHEN q.uniscid = o.uniscid THEN
q.uniscid ELSE
NULL
END
) AS uniscid,
( CASE
WHEN q.regno = o.regno THEN
q.regno ELSE
NULL
END
) AS regno,
( CASE
WHEN q.entname = o.entname THEN
q.entname ELSE
NULL
END
) AS entnameFROM
data_syfr_tem oLEFT JOIN data_qyfr q ON (
o.entname = q.entname OR o.uniscid = q.uniscid OR o.regno = q.regno
)WHERE
o.batchno = '20171213-2'AND STATE = '1';我想把下面的兩個(gè)id合并了 變成 6077 1211 null 測(cè)試單位名稱(chēng)，有大哥能教教嗎。。。DISTINCT on (o.id)我加了這個(gè)的話(huà)，數(shù)據(jù)就變成前兩行的數(shù)據(jù)了，并合并成我想要的這個(gè)樣子
1 回答
當(dāng)年話(huà)下
TA貢獻(xiàn)1890條經(jīng)驗(yàn) 獲得超9個(gè)贊
SELECT o. ID AS ID, ( SELECT uniscid FROM data_qyfr WHERE uniscid = o.uniscid ) AS uniscid, ( SELECT regno FROM data_qyfr WHERE o.regno = q.regno ) AS regno, ( SELECT entname FROM data_qyfr WHERE o.entname=entname ) AS entnameFROM data_syfr_tem oWHERE o.batchno = '20171213-2'AND STATE = '1';
添加回答
舉報(bào)
0/150
提交
取消