Returning first row from a join

vapor · #1 (**permalink**) 05-29-09, 09:45

I have this...

Code:

SELECT d.id AS id, d.name AS name, i.url AS image_url 
FROM destinations d, cities c, destination_images i 
WHERE d.id IN (1,2,3) AND d.closest_city_id = c.id AND i.is_primary_photo = 1 
ORDER BY FIND_IN_SET(d.ID, '1,2,3');

Now I destination_images has many photos with is_primary_photo with 1. It returns all. I just want the first one.

Thanks.

healdem · #2 (**permalink**) 05-29-09, 09:49

have a look at da manuel for the LIMIT clause

r937 · #3 (**permalink**) 05-29-09, 13:02

Quote:

Originally Posted by vapor

destination_images has many photos with is_primary_photo with 1

duh... excuse me, but why do many photos have is_primary_photo = 1 ???

either you should change the data to match the column name, or change the column name from is_primary_photo to something like is_one_of_several_which_all_purport_to_be_primary_ photo

Internet Services

Web Development

Digital Marketing

Consumer Tech