DELETE I

FROM tbItem I (nolock)

INNER JOIN tbProductionOrder PO (nolock)

ON I.POID = PO.POID

WHERE PODescription LIKE '%00000%'

This will delete about 11000000 records

Once again this has been successfully severally