Question

急，asp多表查询问题。

我想写段代码 查询表FOX_xinxi字段yz=0的所有username
再用查出来的所有的username查询表FOX_user 的username字段是否为空，为空就删除掉表表FOX_xinxi中此条信息
有ID字段，我试了一下，还是不行哦。大哥加我，帮我搞定行不？

我试了好多次，还是不行哦.

Answer 1

给你写了个过程，直接可用，注意FOX_xinxi表中是姿橘否有ID字段，迹者团请修正。

sub delfalseuser()
dim urs,urs1,username,uid
set urs=conn.execute("select username from FOX_xinxi where yz=0 order by id desc")
if urs.eof and urs.bof then
urs.close:set urs=nothing
exit sub
else
do while not urs.eof
username=urs("嫌顷username")
uid=urs("id")
set urs1 = conn.execute("select * from FOX_user where username='"&username&"'")
if urs1.eof and urs1.bof then
conn.execute("delete * from FOX_xinxi where id="&uid)
end if
urs1.close:set urs1 = nothing
urs.movenext
loop
urs.close:set urs=nothing
end if
end sub

Answer 2

没看明白，再仔细说说表结构和联系。

Answer 3

select * from FOX_user a inner join (select * from FOX_xinxi where yz = 0) b ON a.username = b.username WHERE a.username = "冲槐纯"
如select出散咐的结果无明态误，delete from FOX_user a inner join (select * from FOX_xinxi where yz = 0) b ON a.username = b.username WHERE a.username = ""