作者yasang (咩)
看板Database
标题[SQL ] 多笔判断
时间Fri Dec 8 11:20:04 2017
资料库名称：SQL2008
资料库版本：不清楚...
内容/问题描述：
大家好
我目前的程式大概是这样
select * from (
SELECT DISTINCT
CASE
WHEN process_status='finish' AND d_date>convert(varchar(8),getdate(),112)
then green_light
WHEN process_status='ready' AND d_date>convert(varchar(8),getdate(),112)
then yellow_light ELSE white_light
END AS LIGHT,
customer.id,
customer.name,
process.status,
d_date,(这些是栏位...)
FROM process
JOIN customer ON customer.id=process.id AND customer.name=process.name
WHERE process.status<>'Y'
) as a
where 1=1
我希望用process.status再做判断
如果process是ready, 则多串另一个资料的栏位状态
ex. 加这栏
↓↓↓↓↓↓
process.no ∣ process status ∣ process flow
－－－－－ ＋－－－－－－－－＋－－－－－－－－－
1 ∣ Y ∣
2 ∣ ready ∣ process 2
3 ∣ finish ∣
CASE
WHEN process.status='ready' (select*from process
JOIN process_flow ON process.no=process_flow.no
THEN
...然後我就卡住了...
请问要怎麽写比较好呢？
谢谢！
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 220.132.185.6
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Database/M.1512703206.A.D94.html