DELETE RA
FROM dbo.RecomAplicInsumoAgric RA
LEFT JOIN dbo.RecomTalhao RT ON RT.IDRecom = RA.IDRecom
WHERE RT.IDTalhao IS NULL