Problem with MySQL query

Posted by Psyche on Stack Overflow See other posts from Stack Overflow or by Psyche
Published on 2010-05-13T17:56:26Z Indexed on 2010/05/13 18:04 UTC
Read the original article Hit count: 153

Filed under:
|

This time my setup looks like this: one table with galleries names (gallery_id, gallery_name) and another table with galleries photos (photo_id, photo_gallery_id, photo_name).

What I need is to get all the galleries with one random picture for each gallery.

Is it possible to do this with a single query?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql