title: LEFT JOIN two tables through a third table
body: <p>How do I <code>LEFT JOIN</code> tables A and B if they can only be connected through a table C?
  So the table C includes a linking attribute that connects it with the table A and <strong>another</strong> attribute that connects it with the table B.</p>