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

Reply via email to