title: Understanding Link-entity in FetchXML
body: <p>I understand <code>&lt;link-entity&gt;</code> is used to do joins, but can you help me translate the following into english?</p>
  
  <pre><code>&lt;entity name = "example"&gt;
  
  *insert a bunch of attributes*
  
       &lt;link-entity name="providercertification" from="providerid" to="vendorid" alias="aa"&gt;
  </code></pre>
  
  <p>I understand <code>&lt;link-entity&gt;</code> is used for joins, but the join type is not specified, so that is throwing me off. How does the link-entity work if no join type is specified? Is it automatically an inner join?</p>
  
  <p>Also, which column does the from part apply <code>to</code>? The very first entity or the one specified in the <code>&lt;link-entity</code>>? </p>
  
  <p>Same question for the <code>from</code> part.</p>