I have a table which has both ChildID and ParentID. Due to the way the data was compiled, in some cases those values are reversed. So I wrote what I thought was a simple Inner Join where both values are reversed and tried to delete the first tables value. I seem to remember this working fine before except now this del