比较复杂的sql语句,请高手帮忙?

[cpzhg]

表test_db

字段
id name1 name2
1 aa1 te1
2 aa2 te2
3 te2 te3
4 te5 te4
5 aa3 te5
以name2为标准,查询出name2字段中的值在name1中出现过并同时删除,执行sql语句上表中的第3,第4条记录将被删除,请问这个sql语句怎么写?

[Net_ufo]

Delete from test_db where name2 in (Select distinct name1 from test_db)

行不?

[cpzhg]

可以,谢谢楼上的

[giftzheng]

查询sql语句
select [distinct] name2 from test_db where name1 in (Select distinct name2 from test_db)

删除sql语句
Delete from test_db where name1 in (Select distinct name2 from test_db)

执行查询sql语句结果集表中的 如果有第3,第4条记录将被删除,

[WebSQL]

Delete from tablename as a where exists (Select 1 from tablename name2=a.name1)

[WebSQL]

Delete from tablename as a where exists (Select 1 from tablename where name2=a.name1)

[mugua604]

--try
Delete from test_db where name1 in (Select distinct name2 from test_db)