62,243
社区成员
发帖
与我相关
我的任务
分享能不能在存储过程中判断需要查询的字段？？
Select nzj.Auto_id,nzj.name,nzj.content,nzj.moment,C.City From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
nzj.moment的字段是1，2的类型，我想如果是1则输出a,是2则输出b,有可能实现么？
nzj.moment的字段是1，2的类型，我想如果是1则输出a,是2则输出b,有可能实现么？
...全文
请发表友善的回复…
发表回复
xiaohutushen 2004-10-27
- 打赏
- 举报
Select nzj.Auto_id,nzj.name,nzj.content,
case nzj.moment
when '1' then 'a'
when '2' then 'b' end as moment,
C.City From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number
case nzj.moment
when '1' then 'a'
when '2' then 'b' end as moment,
C.City From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number
fxyfx 2004-10-27
- 打赏
- 举报
Select nzj.Auto_id,nzj.name,nzj.content,case nzj.moment when 1 then 'a' when 2 then 'b' end as moment,C.City From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
hubinasm 2004-10-27
- 打赏
- 举报
Select nzj.Auto_id,nzj.name,nzj.content,case nzj.moment when 1 then 'a' when 2 then 'b' else '无' end ,C.City From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
xiaohutushen 2004-10-27
- 打赏
- 举报
up
