两个数据表 company 和 menber 他们之间共用email 现在我要删除邮件只存在于表company中在表menber中却没有的记录 请问sql语句怎么写
解决方案 »
- You have an error in your SQL syntax:check the manual that corresponds to....
- php+mysql异常。。。紧急求救!
- 请教一条SQL,结果返回两个统计数字~~~~~~~~~~~
- mysql control center是什么?
- 关于MYSQL CLUSTER中表的索引问题
- 请教postgres COPY问题,急,谢谢!
- mysql insert速度慢
- 十万火急,mysql查询时分不清 "路" 和 “梅”,救我
- c++连接mysql的问题
- 按拼音查询
- mysql如何修改删除check约束?
- sqlserver2000转mysql的方法,哪个最好?
on a.emai=b.emai where isnull(b.emai)or
select a.* from company a left join menber b
on a.emai=b.emai where b.emai is null
不知道你的MY SQL是否支持DELETE a.* from company a left join menber b
on a.emai=b.emai where b.emai is null
where email not in (select email from menber);[align=center]==== 思想重于技巧 ====
[/align]
用
select a.* into newtt from company a left join menber b
on a.emai=b.emai where b.emai is null好一点
on a.emai=b.emai where isnull(b.emai)or
select a.* from company a left join menber b
on a.emai=b.emai where b.emai is null