title: return two tables with get_where
body: <p>I am working in php (codeigniter) and I wish to do this query</p>
  
  <pre><code>SELECT * FROM families, products WHERE family = "madison"
  </code></pre>
  
  <p>in this from</p>
  
  <pre><code>        $query = $this-&gt;db-&gt;get_where("families", array("family" =&gt; $key));
  </code></pre>
  
  <p>when I try </p>
  
  <pre><code>$query = $this-&gt;db-&gt;get_where("families", "products" array("family" =&gt; $key));    
  </code></pre>
  
  <p>it returns errors.  is there anyway to do this?</p>
  
  <p>edit:<br>
      A Database Error Occurred</p>
  
  <pre><code>Error Number: 1054
  
  Unknown column 'products' in 'where clause'
  
  SELECT * FROM (`families`) WHERE `products` IS NULL LIMIT 1
  
  Filename: /Users/Home/Sites/models/family_get.php
  
  Line Number: 5
  </code></pre>
  
  <p>the problem is selecting the two tables</p>