title: MySQL JOIN 3 tables in one query
body: <p>Could you please help me to make this query works</p>
  
  <pre><code>SELECT *
  FROM `SC_orders`
  LEFT  JOIN `SC_customer_reg_fields_values`   using(customerID)
  WHERE (`statusID` = 2 OR `statusID` = 3 OR `statusID` = 21 OR `statusID` = 25 OR `statusID` = 26) AND DATE(order_time) &gt; '2012-12-01 00-00-00'
  LEFT JOIN `SC_ordered_carts`
  ON orderID = orderID
  GROUP BY orderID
  </code></pre>
  
  <p>I try to combine information from 3 tables in one output. This query works fine without last LEFT JOIN and Grouping. Where is my mistake?</p>