Select nzj.Auto_id,nzj.name,nzj.content,
nzj.moment=(case nzj.moment when 1 then 'a' when 2 then 'b' end),C.City
From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number
nzj.moment=(case nzj.moment when 1 then 'a' when 2 then 'b' end),C.City
From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number
,moment=substring('ab',nzj.moment,1)
,C.City
From VetanNew_nizaijian As nzj,VetanNew_City As C Where nzj.area = c.Number
Select nzj.Auto_id,nzj.name,nzj.content,
nzj.moment=(case nzj.moment when '1' then 'a'
when '2' then 'b' end),
C.City
From VetanNew_nizaijian As nzj,VetanNew_City As C
Where nzj.area = c.Number