title: Is it true that all joins following a left join in a SQL query must also be left joins? Why or why not?
body: <p>I remember this rule of thumb from back in college that if you put a left join in a SQL query, then all subsequent joins in that query must also be left joins instead of inner joins, or else you'll get unexpected results. But I don't remember what those results are, so I'm wondering if maybe I'm misremembering something. Anyone able to back me up on this or refute it? Thanks! :)</p>
  
  <p>For instance:</p>
  
  <pre><code>select * from customer
  left join ledger on customer.id= ledger.customerid
  inner join order on ledger.orderid = order.id -- this inner join might be bad mojo
  </code></pre>