This should work, I think..:

DELETE D FROM Table1 AS D

INNER JOIN StoreGroupMember A

ON A.Store_ID = D.Store_ID

WHERE A.StoreNumber = 9833

I think I got the tables right, but it's a bit unclear. Are the StoreNumber and Store_ID fields both in the StoreGroupMember table? And you want to delete by StoreNumber?