时间戳

首页 > 解决方案 > 如何在此查询的这一部分中使用标签？

sql - 如何在此查询的这一部分中使用标签？

问题描述

我试图弄清楚为什么在此查询中以这种方式使用标签时我不断收到相同的错误。我不断收到语法错误。

SELECT idint, elVal.idinterventovalore, concat(cast(elVal.idinterventovalore as varchar(5)) , '=' , valore as label, 1 like value) -- , elVal.IDInterventoRagg
FROM cch.pats_cch_interventi_valori val 
    INNER JOIN cch.pats_cch_interventielencovalori elVal ON val.idinterventoragg = elVal.idinterventoragg AND val.idinterventovalore = elVal.idinterventovalore 
WHERE elVal.idinterventoragg like '%DiaValvulopatiaSede%' AND elVal.IDTipo='I'
ORDER BY idint, elVal.idinterventovalore;

--以下是我正在调试的源代码--

SELECT IDInt, 
       elVal.IDInterventoValore, 
       cast(elVal.IDInterventoValore as varchar(5)) + '=' + Valore as label, 
       1 as [value] -- , elVal.IDInterventoRagg 
FROM AppManager_BI.PATS_CCH_Interventi_Valori val 
  INNER JOIN AppManager_BI.PATS_CCH_InterventiElencoValori elVal 
          ON val.IDInterventoRagg = elVal.IDInterventoRagg 
         AND val.IDInterventoValore = elVal.IDInterventoValore 
WHERE elVal.IDInterventoRagg like 'DiaVasculopatiaPerifericaSede' 
  AND elVal.IDTipo='I' 
ORDER BY IDInt, elVal.IDInterventoValore

标签： sqlpostgresql

解决方案

虽然我不是在postgresql上工作，但我知道你在里面使用别名concat是无效的。试试下面的代码。

SELECT idint, 
           elVal.idinterventovalore, 
           concat(cast(elVal.idinterventovalore as varchar(5)) , '=' , valore, 1) -- , elVal.IDInterventoRagg
      FROM cch.pats_cch_interventi_valori val 
INNER JOIN cch.pats_cch_interventielencovalori elVal 
        ON val.idinterventoragg = elVal.idinterventoragg 
       AND val.idinterventovalore = elVal.idinterventovalore 
     WHERE elVal.idinterventoragg like '%DiaValvulopatiaSede%'
       AND elVal.IDTipo='I'
  ORDER BY idint,
           elVal.idinterventovalore;

希望这会帮助你。

推荐阅读