errore delete inner join

[agenti]

Ciao Ragazzi.
Stamattina sarò ancora rinco ma non capisco perchè questa query non va:


DELETE From
tbl1 Inner Join
tbl2 On tbl1.id_tbl2 = tbl2.ID

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Inner Join

grazie.

[nicola75ss]

delete tbl1.*
from tbl1,tbl2
where tbl1.id_tbl2 = tbl2.id