Problemi delete left join

[oly1982]

if(!isset($_GET['id'])) {exit('la variabile get non esiste!!');}
$sql = " 
DELETE  
FROM hotel  
LEFT OUTER JOIN tariffe  
ON  hotel.idhotel=tariffe.idhotel  
WHERE hotel.idhotel='".intval($_GET['id'])."'  
LIMIT 1";