title: SQL conversion without using JOIN keyword (Oracle jpa)
body: <p>Is there a way to re-write the below without using the JOIN keyword? Like using the old method of joining tables.</p>
  
  <pre><code>SELECT Routes.* FROM Routes
  JOIN (SELECT let,dir,min(num) as minnum
        FROM Routes
        GROUP BY let, dir
        ) ld JOIN Routes tt
  ON tt.let = ld.let AND tt.dir = ld.dir AND tt.num = ld.minnum 
  AND Routes.let = ld.let AND Routes.dir = ld.dir
  WHERE tt.ctry = 'CA';
  </code></pre>