title: What is the left and right table for joins after the first join in SQL(postgresql?
body: <p>I want to know, what constitutes as the left table and the right table after the first join.</p>
  <p>For example:</p>
  <pre><code>From final_productions fp
               left join things.pc p on fp.production_id = p.id
               left join events.time t on fp.tx_id = t.id
               left join things.car c on c.id = fp.channel_id
               right join events.form f on f.production_id = p.id
               left join events.trigger_alert ta on mc.cue_sheet_id = ta.id
  </code></pre>
  <p>I know for the first left join <code>inner join things.pc p on fp.production_id = p.id</code> the left table would be the table in the <code>from statement</code> which is <code>final_productions</code>. But what about the other joins(i.e the joins after the first join statement)? Could someone explain this, please? Thanks</p>