Deleting with joins

[bradenrayhorn]

Is it currently possible to execute a delete query that includes a join? I'd like to be able to do that without running a sub query.

Here is my ideal sql:

DELETE posts
FROM posts
INNER JOIN projects ON projects.project_id = posts.project_id
WHERE projects.client_id = ?

This what I am stuck with now:

DELETE FROM posts
WHERE posts.project_id IN ((
          SELECT posts.project_id
          FROM posts
               INNER JOIN projects ON projects.project_id = posts.project_id
          WHERE project.client_id = ?
     ));

[go-jet]

Hi @bradenrayhorn, thanks for reporting the issue, it helps with prioritising new features for next releases.

Currently mysql delete with join is not supported, support will be added in some of the future releases.

[bradenrayhorn]

Ok, thank you. I look forward to this future release.

[go-jet]

This feature is now implemented in the develop branch and will be released later with release 2.7.0 version.

Delete with join is now possible with USING clause - Sample test