riya_dave (7/17/2013)

---

hi

my query is giving me erro

delete top(1000) from table a

join table b

on a.id = b.id

and b.date < getdate()

error: incorrect syntax near a.

i want to delete top 1000 from table a