Help with SQL delete - anyone?

[william humphrey]

Hi

This SQL select returns records

SELECT * FROM tripulantes
 JOIN linktripulantes ON Link_tripulantes_linktripulantes
 WHERE L_voyageID NOT LIKE 'C%'

but when I do

DELETE FROM tripulantes
 JOIN linktripulantes ON Link_tripulantes_linktripulantes
 WHERE L_voyageID NOT LIKE 'C%'

I get:

 13:20:30 Kernel error: 0x71000. line 2:2: unexpected token: JOIN

How do I select those records to delete which need the link to find?

Thanks for the help!