Query help with distinct

[7724]

HI,

I have a simple query

SELECT DISTINCT alt, galID FROM cfm_gallery LIMIT 12

Which works great, but I also want to add another field to the query

photo

But I don't want that field to be distinct, how do I do this?

Thanks

Chris

[guido2004]

Why don't you want the photo field to be distinct?

[7724]

As the galID holds different values such as 54, 55, 56

But the photo contains the filename, which is sometimes called the same thing

[guido2004]

So?

SELECT DISTINCT alt, galID, photo FROM cfm_gallery LIMIT 12

will give you all alt-galID-photo values without duplicates.
galID 54 with photo 'john' and galID 55 with photo 'john' will both be selected.

If this isn't what you want, then please post an example of the data present in your table, and the result you'd like the query to have.