• Try this...

    DELETE FROM tbItem l (nolock)

    Where exists(Select p.POID From tbProductionOrder p (nolock) where l.POID = p.POID AND PODescription LIKE '%00000%')