知道為什么此查詢回傳錯誤“SQL 錯誤 (207): Invalid column name 'BTC'”嗎？
我只是想在 JOIN 陳述句之后使用 WHERE 子句
WITH balances AS (
SELECT
UserId,
Balance,
CASE
WHEN CurrencyId = '123' THEN 'BTC'
WHEN CurrencyId = '456' THEN 'USD'
WHEN CurrencyId = '789' THEN 'BSV'
WHEN CurrencyId = '987' THEN 'CAD'
WHEN CurrencyId = '765' THEN 'ECD'
WHEN CurrencyId = '543' THEN 'XLM'
WHEN CurrencyId = '321' THEN 'ETH'
WHEN CurrencyId = '0123' THEN 'GBP'
WHEN CurrencyId = '0345' THEN 'BCH'
WHEN CurrencyId = '0567' THEN 'EUR'
WHEN CurrencyId = '0789' THEN 'USD as WSD'
END AS Currency
FROM "mydb"."dbo"."Balances" balance
WHERE balance.Balance > 0.01
)
SELECT TOP 500
curUser.Id,
curUser.Email,
balance_btc.Balance AS BTC,
balance_btc.Currency,
curUser.LastBalanceSnapshot
FROM "mydb"."dbo"."Users" AS curUser
INNER JOIN balances balance_btc ON balance_btc.UserId = curUser.Id
WHERE balance_BTC.Currency = "BTC";
uj5u.com熱心網友回復：
您似乎在 WHERE 子句中使用了不正確的文本限定符 - 雙引號表示識別符號，而不是值。換句話說，您的 WHERE 子句的撰寫方式是 SQL Server 試圖在兩列之間找到相等性，而不是等于某個值的列。
更改您的代碼，以便您的WHERE子句讀取
WHERE balance_BTC.Currency = 'BTC';并且您應該發現錯誤已解決。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/414986.html
標籤：