title: Outer join of 2 tables in Bookshelf.js or Knex.js
body: <p>I am new to Bookshelf.js and knex.  I need to write a query equivalent to this in Bookshelf/ knex  </p>
  
  <pre><code>SELECT Inv.*, Comp.* 
  FROM  Inv,   Comp
  WHERE Inv.uId =2 AND Comp.cId = Inv.cId;
  </code></pre>
  
  <p>Inv Table has:</p>
  
  <pre>
  Id     |  primary key, integer  not null
  col1   | string data
  cId    | integer, foreign key references C table
  uId    | integer  foreign key reference U table      
  </pre>
  
  <p>Comp Table has:</p>
  
  <pre>
  cId     |  primary key, integer  not null 
  col3    | string data
  </pre>