title: SQL - alternative to left outer join
body: <p>There is a standard way in SQL to conut a number of rows joined to one table acepting also the 0?
  That is one example :</p>
  
  <pre><code>SELECT t1.id, COUNT(t2.*)
  FROM t1 LEFT OUTER JOIN t2 ON ( t1.id = t2.id )
  GROUP BY t1.id
  </code></pre>
  
  <p>I need a alternative because i use odbc with different databases, and on some databases the left join aren't supported.</p>