title: Medoo Syntax for Join Query with Two Foreign Keys
body: <p>I've a requirement to perform a join operation in SQL with two foreign keys on same table. The answer in below post has the SQL for my requirement. </p>
  
  <p><a href="https://stackoverflow.com/questions/32622252/join-on-two-foreign-keys-from-same-table-in-sql">Join On Two Foreign Keys From Same Table In Sql</a></p>
  
  <p>I am trying to convert this query into <a href="https://medoo.in" rel="nofollow noreferrer">Medoo</a> syntax, but I don't get the desired output. Code posted below is my latest effort which doesn't work.</p>
  
  <pre><code>$db -&gt; select( "item_tbl", [ "[&gt;]user_tbl.id" =&gt; ["ownerId", "lastModifiedById"] ], ["username", "username", "itemName"]);
  </code></pre>
  
  <p>Could somebody please help?</p>