Specify the type of join and the join criterion. The FROM clause lists the table MATCH_11 twice. Thus, the table is joined with itself. The WHERE clause returns only the rows for each pair that show the difference when the values for control are subtracted from the values for case.


      from match_11 one, match_11 two
      where (one.pair=two.pair and one.low>two.low);