求delete用法。。。

[hkongm]

我做了一个查询

SELECT dbo.Reply.*, dbo.Topic.*
FROM dbo.Reply INNER JOIN
dbo.Topic ON dbo.Reply.ID = dbo.Topic.ID
WHERE (dbo.Topic.BoardID = 7)

怎么用delete把这个结果集删掉？

[gmlxf]

delete dbo.Reply where dbo.Reply.ID
in
(SELECT dbo.Reply.ID
FROM dbo.Reply INNER JOIN
dbo.Topic ON dbo.Reply.ID = dbo.Topic.ID
WHERE (dbo.Topic.BoardID = 7)
)

delete dbo.Topic where dbo.Topic.ID
in
(SELECT dbo.Reply.ID
FROM dbo.Reply INNER JOIN
dbo.Topic ON dbo.Reply.ID = dbo.Topic.ID
WHERE (dbo.Topic.BoardID = 7)
)

[pengdali]

select id into #temp from Topic where BoardID = 7 and id in (select id from Reply)
delete Topic where id in (select id from #temp)
delete Reply where id in (select id from #temp)
go
drop table #tmep

[Benimarunikado]

DELETE FROM dbo.Reply WHERE ID IN(
SELECT dbo.Reply.ID,dbo.Topic.ID
FROM (
SELECT dbo.Reply.*, dbo.Topic.*
FROM dbo.Reply INNER JOIN
dbo.Topic ON dbo.Reply.ID = dbo.Topic.ID
WHERE (dbo.Topic.BoardID = 7)
)AS YOURWANT)

GO

DELETE FROM dbo.Topic WHERE ID IN(
SELECT dbo.Reply.ID,dbo.Topic.ID
FROM (
SELECT dbo.Reply.*, dbo.Topic.*
FROM dbo.Reply INNER JOIN
dbo.Topic ON dbo.Reply.ID = dbo.Topic.ID
WHERE (dbo.Topic.BoardID = 7)
)AS YOURWANT)

命令已成功完成。

[hkongm]

哇！谢谢各位，我去试试