![]() |
#2
师妃暄2009-11-11 10:44
|
select wl_jz, somx_xqsl ,wl_wlid ,(wl_jz*somx_xqsl)=
case
when wl_jldw='百米' then wl_jz*somx_xqsl/10
when wl_jldw='米' then wl_jz*somx_xqsl/100
from jserp.wl ,jserp.somx
where wl_wlid=somx_wlid
and somx_soid='092222'
---------------------------------
请高手看看这SQL 语句 哪里出现错误了 ..