We're trying to get a particular office's data out of our main database. I can easily pull all their data into another table with a sql statement. Then what I'd like to do is:

select MainTable
delete for item_id in (select item_id from OtherTable)

But apparently that doesn't work.

My backup plan is a loop but I was wondering if there's a sql way to do it. Thanks!