title: Using subselect to accomplish LEFT JOIN
body: <p>Is is possible to accomplish the equivalent of a LEFT JOIN with subselect where multiple columns are required.
  Here's what I mean.</p>
  
  <pre><code>SELECT m.*, (SELECT * FROM model WHERE id = m.id LIMIT 1) AS models FROM make m
  </code></pre>
  
  <p>As it stands now doing this gives me a 'Operand should contain 1 column(s)' error.</p>
  
  <p>Yes I know this is possible with LEFT JOIN, but I was told it was possible with subselect to I'm curious as to how it's done.</p>