PHP/MySQL DELETE on multiple rows with inner join -

i'm working on website school project. i'm having trouble while trying delete multiples rows in database, here's query:

$dbh->query("delete enseigne e inner join cours c on c.id_cours = e.id_cours e.id_prof = '$id_prof' , c.id_matiere = '$matt' ");

with $id_prof , $matt can replaced number inferior 5.

the 2 tables have 2 columns:

my problem error 1064 while running command , after 3h changing query still haven't found problem.

if want delete enseigne query be

delete e  enseigne e  inner join cours c on c.id_cours = e.id_cours  e.id_prof = '$id_prof'  , c.id_matiere = '$matt'

and deleting both tables

delete e , c enseigne e  inner join cours c on c.id_cours = e.id_cours  e.id_prof = '$id_prof'  , c.id_matiere = '$matt'

UV code