delete 如何删除串表的数据?

要删除的数据 在一个表内 。。但需要通过串表才能找出这些数据。但是delete怎么删除带join的语句???
[54 byte] By [backhead] at [2008-1-9]
# 1
根据条件一个表一个表删除
fellowcheng-鹰击长空 at 2007-10-18 > top of Msdn China Tech,MS-SQL Server,基础类...
# 2
貌似只好一个一个删,或者用触发器..
# 3
用where条件指定
hellowork-一两清风 at 2007-10-18 > top of Msdn China Tech,MS-SQL Server,基础类...
# 4
会写select就会写delete,呵呵。
mengmoumengmou at 2007-10-18 > top of Msdn China Tech,MS-SQL Server,基础类...
# 5
select 的 语句是这样的
select lzk.id from lzk right join (select lz_zh from lzk where dd_bh='wwww')w on lzk.lz_zh=w.lz_zh
backhead at 2007-10-18 > top of Msdn China Tech,MS-SQL Server,基础类...
# 6
try:
delete lzk from lzk right join (select lz_zh from lzk where dd_bh='wwww')w on lzk.lz_zh=w.lz_zh
akuzou-启航 at 2007-10-18 > top of Msdn China Tech,MS-SQL Server,基础类...
# 7
delete from lzk where lzk.id in(select lzk.id from lzk right join (select lz_zh from lzk where dd_bh='wwww')w on lzk.lz_zh=w.lz_zh)