从4个表中检索数据

Question

I have these four table assume that ring table consist of five fields(jewelry_id,ring_id,image,type,brand_id)

Note that brand table have its foreign key in ring table and ring and style both have foreign keys in ring_style table. now i want to retrieve the following data from these four table (ring_id, image,type, brand,style) but did't get the query any help will be greatly appreciated.

Answer 1

SELECT
    ring_id, image, type,
    brand,
    style
FROM      ring
LEFT JOIN brand ON ring.brand_id = brand.brand_id
LEFT JOIN ring_style ON ring.jewelry_id = ring_style.jewelry_id
     LEFT JOIN style ON ring_style.style_id = style.style_id

Note that each ring will appear one or more times. It will appear more than one time when there is more than one ring_style record for the ring.