mysql - LEFT JOIN 3 个表 sql OpenCart

Question

我需要将这个函数中的另一个表与名称供应商连接起来，这可能吗

public function getProducts($data = array()) {
      $sql = "SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "'";

Answer 1

  $sql = "
  SELECT c.olumns, y.ou, a.ctually, w.ant 
    FROM product p 
    JOIN product_description pd 
      ON pd.product_id = p.product_id
    JOIN vendors v
      ON v.product_id = p.product_id
   WHERE pd.language_id = ?
   ORDER 
      BY p.product_id;
   ";

现在看看准备好的语句