UC知道：想知道神马，提问回答学习问题百度都知道

delete from bumen,yuangong where bumen.bumenid=yuangong.yuangongid and bumen.bumenid=1

来源：百度知道编辑：UC知道时间：2024/06/23 04:03:05

消息 102，级别 15，状态 1，第 1 行
',' 附近有语法错误。

错哪了？

删除2个表中，字段相同，并且值为1的某行

当然有错了, SQL是不允许这么做的, 正确的应该这样:

delete from bumen
where exists (select 'x' from yuangong b where bumen.bumenid=b.yuangongid and bumen.bumenid=1)

delete from bumen join yuangong on bumen.bumenid=yuangong.yuangongid where bumen.bumenid=1
看这个行不

delete from bumen,yuangong where bumen.bumenid=yuangong.yuangongid and bumen.bumenid=1 如果逗号及点号正确的话，这句应该是正确的啊

如何恢复sqlserver2005 delete from 数据 Coming my way from across the parking lot was ___ society would consider a bum. Valentina - Bum Bum bum是什么意思 sybase 数据库操作 delete from where 如果delete form不加表名会出现什么后果 sqldel="delete from book where id="&request("id") exec="delete * from guestbook where id="&request.form("id")" rs.open "delete * from NEWS where id="&request("id"),conn,1 SQL SERVER 2000我不小心执行了DELETE FROM 后面没根参数,怎么办 SqlStmt = "DELETE FROM Customer WHERE CustId='" + Trim(TmpId) + "'"