select a.*,b.resversn from ywty_jykzxx a,tfrc_transcfg b where REPLACE(b.resname,'tran','')=a.jydm order by b.resname desc,b.resversn desc
b.resname,a.jydm,这两个字段都是char型的,好象在这里这个语句不起作用呢,好象是replace不起作用
b.resname,a.jydm,这两个字段都是char型的,好象在这里这个语句不起作用呢,好象是replace不起作用
where REPLACE(b.resname,'tran','')=a.jydm
order by a.jydm desc,b.resversn desc 改成這樣試試!
where REPLACE(b.resname,'tran','')=a.jydm
order by a.jydm desc,b.resversn desc
(a.jydm) order by b.resname desc,b.resversn desc
b.resname,a.jydm