Since EXCEPT returns the left side of a query, once duplicates are deleted from the select on the right, how might one get the !Left AND !Right rows, i.e., the rows which are not in *both* the left and right selects. I had thought EXCEPT did this, but it doesn't, and I was wondering if SQlite had a way to do this that did not involve doing except on both, switching the 'left' and the 'right'.
--Keith