title: SQL Help Needed
body: <p>Below is a simplified version of my table.</p>
  
  <pre><code>    FRID, RELFRID, Relationship
      123, 456, Husband/Wife
      456, 123, Wife/Husband
      345, 765, Brother/Sister
      765, 345, Sister/Brother
  </code></pre>
  
  <p>I want to pull only one representation of the relationship (just one of each set of two records).  I have tried a number of things including EXCEPT and SUBSELECTS and everything I try results in nothing because every number on the left is also represented on the right.  Any idea how to get the results I'm looking for?  I've tried every combination of the queries below.</p>
  
  <pre><code>    select frid, relfrid from frrelmst
      except
      select frid, relfrid from frrelmst
      where frid in (select relfrid from frrelmst)
      order by frid, relfrid
  
      Select frid, relfrid from frrelmst where 
      relfrid+frid not in (select frid+relfrid from frrelmst)
  </code></pre>