title: Are "from Table1 left join Table2" and "from Table2 right join Table1" interchangeable?
body: <p>For example, there are two tables:</p>
  <pre><code>create table Table1 (id int, Name varchar (10))
  
  create table Table2 (id int, Name varchar (10))
  </code></pre>
  <p>Table1 data as follows:</p>
  <pre><code>    Id     Name     
      -------------
      1      A        
      2      B    
  </code></pre>
  <p>Table2 data as follows:</p>
  <pre><code>    Id     Name     
      -------------
      1      A        
      2      B 
      3      C
  </code></pre>
  <p>If I execute both below mentioned SQL statements, both outputs will be the same:</p>
  <pre><code>select *
  from Table1
    left join Table2 on Table1.id = Table2.id
  
  select *
  from Table2
    right join Table1 on Table1.id = Table2.id
  </code></pre>
  <p>Please explain the difference between left and right join in the above SQL statements.</p>