# pt-archiver - multitable delete or delete from with join

**URL:** <https://forums.percona.com/t/pt-archiver-multitable-delete-or-delete-from-with-join/4898>\
**Category:** Percona Toolkit\
**Created:** [May 24, 2016, 1:51am UTC](https://forums.percona.com/t/pt-archiver-multitable-delete-or-delete-from-with-join/4898 "2016-05-24T01:51:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Logger](https://avatars.discourse-cdn.com/v4/letter/l/34f0e0/32.png) [@Logger](https://forums.percona.com/u/Logger)\
**Post date:** [May 24, 2016, 1:51am UTC](https://forums.percona.com/t/pt-archiver-multitable-delete-or-delete-from-with-join/4898/1 "2016-05-24T01:51:02Z")

</div>

Hi everybody.  
Can we use pt-archiver for archiving or purging data from tables with FK using join. I did not find any examples or info in documentation about this.  
Can you advice?

Example delete query.

delete testdb1.tbl1 from testdb1.tbl1  
inner join testdb1.tbl2 on testdb1.tbl1.tbl1\_id=testdb1.tbl2.tbl2\_id  
where testdb1.tbl2.updated=?