> 
> **Possible Duplicate:**  
> 
> [MySQL delete row from multiple tables](https://stackoverflow.com/questions/2214433/mysql-delete-row-from-multiple-tables) 
> 
> 
> 

I have 5 tables:

* members
* member\_videos
* member\_photos
* member\_friends
* member\_pages

When I delete that member, I want to delete all his records from these tables. `member_id` exist in all tables. I'm doing this with 5 queries for each table. Can I use `LEFT JOIN` or something like this do to this in one query?
['https://Stackoverflow.com/questions/9249793', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1020895/']
Yes, you can.

```
DELETE m, mv, mp, mf, mpp
FROM members AS m
LEFT JOIN member_videos  AS mv  ON mv.member_id = m.id
LEFT JOIN member_photos  AS mp  ON mp.member_id = m.id
LEFT JOIN member_friends AS mf  ON mf.member_id = m.id
LEFT JOIN member_pages   AS mpp ON mpp.member_id = m.id
WHERE m.id = 12

```
<http://dev.mysql.com/doc/refman/5.0/en/delete.html>

Check this page, there is a section for multiple-tables DELETE.