我写了一个查询,那就是连接两个表。但我已经被占了00904了。00000 -付费用户的"%s:无效标识符“。这就是我的问题
SELECT za.TAH_DONEM,
za.ABONE_ID,
za.URUN_ID,
za.ID,
za.TARIFE_ID,
tp.tarıfe_gecerlık_ıd,
(select sum(ucret) from schemaName.TARIFE_Fas f where f.xx_id=tp.xx_id and f.ucret_turu_id!=11400) AS paid
FROM schemaName.Z_ABONE_URUN za
INNER JOIN schemaName.TARIFE_PLAN tp
ON za.TARIFE_ID = tp.TARIFE_ID
where za.tah_donem=201905 and paid=0;谢谢
发布于 2020-06-09 20:42:24
您不能像这样引用外部查询中的列,但您可以尝试这样做:
SELECT * FROM
(
SELECT za.TAH_DONEM,
za.ABONE_ID,
za.URUN_ID,
za.ID,
za.TARIFE_ID,
tp.tarıfe_gecerlık_ıd,
(
SELECT SUM(ucret)
FROM schemaName.TARIFE_Fas f
WHERE f.xx_id=tp.xx_id AND f.ucret_turu_id != 11400
) AS paid
FROM schemaName.Z_ABONE_URUN za INNER JOIN schemaName.TARIFE_PLAN tp ON za.TARIFE_ID = tp.TARIFE_ID
WHERE za.tah_donem = 201905
)tmp WHERE tmp.paid=0;https://stackoverflow.com/questions/62282791
复制相似问题