I do have two mysql tables named Services and Images. Each service may have multiple images.
So my question is, just I need to make a SELECT query to get all services with one image to each service.
This is how I tried it. But it gave me all services and all images to each service.
SELECT s.id
, s.name
, s.description
, i.id as image_id
, i.image
FROM services s
LEFT JOIN images i ON i.service_id = s.id;
Can anybody tell me how I make this query correctly?
Thank you.
IF you need just one image for one service you can group by your service id
SELECT s.id
, s.name
, s.description
, i.id as image_id
, i.image
FROM services s
LEFT JOIN images i ON i.service_id = s.id
GROUP BY s.id;
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments