一个查询中的三个表？ [关闭]

Question

=================
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
=================

i want to display in html :

and i get id_kategori from URL : product.php?id_kategori=1

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

how call SQL in one query ???

Answer 1

try

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