一个查询中的三个表 - Three table in one query?

Three table in one query?

本文关键字：三个查询一个 | 更新日期: 2023-10-23

=================
Table : tb_kategori
- id_kategori (primary key)
- name_kategori
=================
=================
Table : tb_product
- id_product (primary key)
- id_kategori (foreign key)
- name_product
=================
=================
Table : tb_images
- id_images (primary key)
- id_product (foreign key)
- file_images
=================

我想在 HTML 中显示：

我从网址得到id_kategori：产品.php？id_kategori=1

<ul>
  <li>
    <img src="[file_images]">
    <div>
      <h1>[name_product]</h1>
    </div>
  </li>
</ul>

如何在一个查询中调用 SQL ???

试试

SELECT * 
FROM
     tb_kategori k,tb_product p,tb_images i
WHERE k.id_kategori = p.id_kategori
  AND p.id_product = i.id_product