从2个不同的mysql表中选择

Question

I have 2 tables one for products and one for images i need to get all products with its related images. and all products with only one image for each

Answer 1

get all products with its related images

Do a inner join like

select p.product_title,
i.*
from products p join images i on p.product_id = i.image_product;

all products with only one image for each

Perform a group by and then join like

select p.*
from products p join (
select img_product
from images
group by img_product
having count(distinct img_product) = 1) xxx on p.product_id = xxx.img_product;