DELETE JOIN av

DELETE a FROM load_avto a
LEFT JOIN shoc_product p ON p.product_id=a.id_product
WHERE isnull(p.product_id);