从一个表中选择一个来自其他表的一个字段的行

Question

What i want, to display rows from a table which is selected by a field from other table single value, lets say to display images from a table by last category id.

I have this type of query, but this return me all matching keys rows, if i inset LIMIT 1 then it return one row...

SELECT i.prof_image FROM profile_images i
JOIN images_cat cat ON (cat.cat_id = i.cat_id)
GROUP BY i.prof_image; 
//OR LIMIT 1;

Any idea to fix this problem. (i.e. displaying the latest category images)?

Answer 1

This will work for your specific example.. If you need to be more selective, then please post some more details..

SELECT i.prof_image 
FROM profile_images i 
WHERE cat_id = (select max(cat_id) from images_cat)