Home Forums SQL Server 2005 Administering Delete RE: Delete
Sangeeta Satish Jadhav-362431
SSC Enthusiast
Points: 106
More actions
June 12, 2008 at 5:05 am
#827744
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%')