Hello

Assuming I have the following table:

CREATE TABLE photo_in_album (
Album_ID INT UNSIGNED NOT NULL,
Image_ID INT UNSIGNED NOT NULL,
) ENGINE=MYISAM DEFAULT CHARSET=latin1;

which provides a many-to-many relationship between photos and albums.

Is it possible to extract each album and the first photo in that album?
Here is an example:
Album Photo
1 1042
1 1046
1 1439
2 158
2 1582
2 1585
3 4354
3 96
3 99

The query will return:
(1, 1042)
(2, 158)
(3, 4354)

thanks