SQL语法错误

sss9180

delete
from rdrecord
where id in

Select distinct rdrecord.id
from rdrecord
left join rdrecords on rdrecords.id=rdrecord.id

where cvouchtype='01'
and caccounter is null
and autoid is null


运行后提示select附近有语法错误

wozengcong

Select distinct rdrecord.id
from rdrecord
left join rdrecords on rdrecords.id=rdrecord.id

where cvouchtype='01'
and caccounter is null
and autoid is null

加小括号试试，还有on修改成where，where修改成and

火焙鱼

delete
from rdrecord
where id in(Select distinct rdrecord.id
from rdrecord
left join rdrecords on rdrecords.id=rdrecord.id
where (cvouchtype='01'
and caccounter is null
and autoid is null))

这样对了吧，(*^__^*) 嘻嘻

sss9180

谢谢你们，我试试，谢谢
感激不尽！！

sparkie

不删掉结转失败是吗

sss9180

sparkie 发表于 2013-1-3 19:25

                               
登录/注册后可看大图

不删掉结转失败是吗

{:soso_e109:}