Hi
i have table called car.. that consist of

id, photo,brand,model,photo.

I want to display the photo of all the cars that have brand suppose KIA. As the brands may consists of many model.


So the main query is -- I want to display the photo of only one car from each model of brand KIA..

suppose: i have values like..
brands = KID model = 2
brands = KID model = 2
brands = KID model = 2
brands = KID model = 3
brands = KID model = 4

I donot want to display all but only one car from each model of brand KIA.

I was using query like

select * from make where brand='KIA' and model in (select (model) from make group by model.

But is not working correctly.
Plz clear it.