Delete query using JOIN in MYSQL

    Delete query using JOIN in MYSQL
  
    we can delete the record using join
  
    DELETE table-name FROM table-name
    JOIN table-name1 ON table-name.id=table-name1.refID
    WHERE
     Condition