delete 如何删除串表的数据?

要删除的数据在一个表内。。但需要通过串表才能找出这些数据。但是delete怎么删除带join的语句？？？

[54 byte] By [backhead] at [2008-1-9]

# 1

根据条件一个表一个表删除

# 2

貌似只好一个一个删,或者用触发器..

# 3

用where条件指定

# 4

会写select就会写delete，呵呵。

mengmoumengmou at 2007-10-18 >

# 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 >

# 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 >

# 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)

MS-SQL Server Hot Topic