如何在case语句中应用条件
如何在case语句中应用条件
提问于 2016-01-15 06:15:56
SELECT Sales_Contract.ContNo, Sales_Contract.Date, PartyMst.PName as PartyName, Customer.CustName as Customer,
ItemMst.ItName as ItemName, Sales_Contract.Grade,
Sales_Contract.Rate, Sales_Contract.Weight,
case when @Pending=1 then (Sales_Contract.BalWeight > 0) else Sales_Contract.BalWeight end
FROM Sales_Contract LEFT OUTER JOIN
ItemMst ON Sales_Contract.ItCd = ItemMst.ItCd LEFT OUTER JOIN
Customer ON Sales_Contract.Customer = Customer.CustCd LEFT OUTER JOIN
PartyMst ON Sales_Contract.SPartyCd = PartyMst.PartyCd那么，在我的语句case when @pending=1中，我想显示表Sales_Contract中的BalWeight>0 value值
回答 1
Stack Overflow用户
回答已采纳
发布于 2016-01-15 06:18:16
在Where子句中添加筛选器，而不是select。尝尝这个
SELECT sales_contract.contno,
sales_contract.date,
partymst.pname AS PartyName,
customer.custname AS Customer,
itemmst.itname AS ItemName,
sales_contract.grade,
sales_contract.rate,
sales_contract.weight
FROM sales_contract
LEFT OUTER JOIN itemmst
ON sales_contract.itcd = itemmst.itcd
LEFT OUTER JOIN customer
ON sales_contract.customer = customer.custcd
LEFT OUTER JOIN partymst
ON sales_contract.spartycd = partymst.partycd
WHERE ( @pending = 1
AND sales_contract.balweight > 0 )
OR @pending <> 1页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/34805328
复制相关文章
相似问题
腾讯云开发者
