title: SELECT multiple columns from 4 different TABLES
body: <p>I have 4 tables: order, order_product, product, product_description.</p>
  
  <p>I am trying to get the following colomuns from these four tables:
  <strong>author</strong>(product_description),<strong>name</strong>(product_description), <strong>model</strong>(product),<strong>order_id</strong>(order)
  WHILE the order.order_status_id=1</p>
  
  <p>I am using this query:</p>
  
  <pre><code>SELECT          product_description.name AS name
          product_description.author AS author
          product.model AS model
              `order`.`order_id` AS `order_id`
  FROM product_description
  INNER JOIN product_description ON product.product_id=product_descripton.product_id
  INNER JOIN product ON `order`.product_id=product.product_id
  INNER JOIN `order` ON `order_product`.`order_id`=`order`.`order_id`
  WHERE `order`.`order_status_id`=1
  </code></pre>
  
  <p>But it doesn't work.
  Any suggestions?</p>
  
  <p>Thank you!</p>