Shoot me now, I need JOIN help

[eluser]slowgary[/eluser]
That was the topic of another thread already, using a table for product images or not. Ultimately I decided the table was the best root because the alternative would require a directory scan and looping through the entire returned array from that scan. Additionally, the database table allows for image descriptions or other info.

If there were only one image per product I would skip the table and just use a suffix of the product sku for the filename. I will likely name the images with some sort of suffix anyway, just to keep it organized.

I'm not an SQL master, but it seems that this would be a fairly common requirement from a query. So short of using a JOIN and skipping duplicate products in PHP, is there no way to query one table and tack onto each row a JOINed row LIMIT 1?