delete删除多表

1、DELETE a.*, aa.* FROM student a, person aa WHERE a.id = aa.city_id AND a.name = ''

2、DELETE a.*, aa.* FROM student a inner join person aa on a.id = aa.city_id WHERE a.name = ''

3、DELETE a.*, aa.* FROM student a left join person aa on a.id = aa.city_id WHERE a.name = ''

posted @ 2016-09-05 10:14  loweringye  阅读(158)  评论(0)  编辑  收藏  举报