~~~~~~~~~SQL语句,请大家帮帮小弟，过来看看,在线等待，马上给分~~~~~~~~

Question

select 
w.web_order_number,
w.web_order_date,
w.delivery_flag,
(case when w.delivery_flag=N then 0 else isnull(d.delivery_code,9999) end) delivery_code
w.delivery_address
from web_order w 
left join delivery_code d on w.delivery_address=d.delivery_address
where web_order_number=160114

Answer 1

select 
w.web_order_number,
w.web_order_date,
case when w.delivery_flag='N' then 0
     when ... then ...
end,w.delivery_address
from web_order w 
left join delivery_code d on w.delivery_address=d.delivery_address
where web_order_number=160114

Answer 2

select 
w.web_order_number,
w.web_order_date,
w.delivery_flag,
d.delivery_code,
w.delivery_address,
case when w.delivery_flag='N' then 0 when w.delivery_flag='Y' then isnull(d.delivery_code,9999) end 
from web_order w 
left join delivery_code d on w.delivery_address=d.delivery_address
where web_order_number=160114