两表之间的删除问题

[SharnWong]

select * from A,B where A.id=B.id and B.code=112101
如果要删除怎么些呢
delete from A,B where A.id=B.id and B.code=112101不对- -！
请高手赐教

[水族杰纶]

--你要刪除A還是B?
delete A from A,B where A.id=B.id and B.code=112101
delete B from A,B where A.id=B.id and B.code=112101

[SharnWong]

哈哈 太大意了 谢谢了

[lgxyz]

你没指定要删除哪个表

[lovelan1748]

能不能同时删掉呢

[ccjjww1222]

可以用子查询做

[bluefangxiao]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL code--你要刪除A還是B?
delete A from A,B where A.id=B.id and B.code=112101
delete B from A,B where A.id=B.id and B.code=112101
[/Quote]
up

[lihan6415151528]

如果要删除怎么些呢

看了半天才知道 是

如果要删除怎么写呢

[yangxuebao123]

delete from (select * from A,B where A.id=B.id and B.code=112101)

[cnkiminzhuhu]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL code--你要刪除A還是B?
delete A from A,B where A.id=B.id and B.code=112101
delete B from A,B where A.id=B.id and B.code=112101
[/Quote]
顶