Delete from one table with join

by

I am not sure about your requirement.
What I understood from your question is you want to delete all the emails of jobs which are closed.
try this one;

DELETE e FROM emailNotification e 
LEFT JOIN jobs j ON j.jobId = e.jobId 
WHERE j.active = 1 AND CURDATE() < j.closeDate

More Related Contents:

  1. Deleting rows with MySQL LEFT JOIN
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. Remove duplicate rows in MySQL
  4. Left Outer Join doesn’t return all rows from my left table?
  5. How to delete from multiple tables in MySQL?
  6. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  7. Left Join not returning all rows
  8. MySQL DELETE FROM with subquery as condition
  9. How to use mysql JOIN without ON condition?
  10. SQL query: Delete all records from the table except latest N?
  11. sql join two table
  12. Difference in MySQL JOIN vs LEFT JOIN
  13. SQL DELETE with JOIN another table for WHERE condition
  14. LEFT JOIN only first row
  15. MySQL: How do I join same table multiple times?
  16. MYSQL Left Join COUNTS from multiple tables
  17. Mysql delete statement with limit
  18. How do I delete all the duplicate records in a MySQL table without temp tables
  19. Postgres LEFT JOIN with WHERE condition
  20. MySQL LIMIT on DELETE statement
  21. Delete all rows with timestamp older than x days
  22. Deleting a row based on the max value
  23. delete rows from multiple tables
  24. Deleting millions of rows in MySQL
  25. How to store multiple options in a single table?
  26. Get the new record primary key ID from MySQL insert query?
  27. MySQL trigger On Insert/Update events
  28. How can I change MariaDB to MySQL in XAMPP?
  29. Automatic Rollback if COMMIT TRANSACTION is not reached
  30. Sum until certain point – MySql

Leave a Comment