delete jxc_bm_sp1 from jxc_bm_sp1 sp ,(select * from jxc_bm_sp a,jxc_bm_sp1 b where a.bm=b.bm) tmp where sp.bm=tmp.bm
服务器: 消息 8156,级别 16,状态 1,行 1
多次为 'tmp' 指定了列 'bm'。
怎么解决?
服务器: 消息 8156,级别 16,状态 1,行 1
多次为 'tmp' 指定了列 'bm'。
怎么解决?
from
jxc_bm_sp1 sp ,
(select * -----这个*里,2个表jxc_bm_sp ,jxc_bm_sp1 里都有bm 字段,你要指定是哪一个
from jxc_bm_sp a,jxc_bm_sp1 b where a.bm=b.bm) tmp
where sp.bm=tmp.bm
from jxc_bm_sp1 sp ,
jxc_bm_sp tmp
where sp.bm=tmp.bm
不知道你要干嘛