title: convert sql query to Zend DB query
body: <p>I have tow table :
  article,sub_categories
  how to convert this query to zend Db query join</p>
  
  <p>$sql="</p>
  
  <p>SELECT <code>article</code>.*, <code>sub_categories</code>.<code>name_arabic</code> AS <code>sub_category_name_arabic</code>, <code>sub_categories</code>.<code>name_english</code> AS <code>sub_category_name_english</code>, <code>article</code>.<code>sub_category_id</code> AS <code>sub_categories_id</code> FROM <code>article</code> 
                      LEFT JOIN <code>sub_categories</code> ON <code>article</code>.<code>sub_category_id</code> = <code>sub_categories</code>.<code>id</code>
                      WHERE <code>article</code>.<code>active</code> = 1
  "; </p>
  
  <p>Please need help</p>
  
  <p>Thanks with regard</p>