SELECT A.*,(JYF000+JE0000) HJJE01 FROM VW_YF_BQLYDNEW_MSQL A WHERE CKDH00='582439'
 and A.ZYID00 = 17253
 ORDER BY A.CH0000,A.ZYID00,CLBZ00

------------Ôö¼Óyzid00 ÅÅÐò