Hi folks,

Probably the simplest question ever but one thats eluded answering for myself

I have a table with say 10 records and say that the records have a location field. How would I select only records with different locations ?

Eg:

1 - Jim - Florida
2 - Mark - Texas
3 - Kim - Florida
4 - Phil - Boston
5 - Gary - Los Angeles
6 - Warren - Texas
7 - Will - Florida
8 - Grant - Texas
9 - Lisa - New York
10 - Julie - New York

So my SELECT statement would produce :

1 - Jim - Florida
2 - Mark - Texas
4 - Phil - Boston
5 - Gary - Los Angeles
9 - Lisa - New York

I would want the full record returned not just the location.

Many thanks people, hope you can help

Regards,

Rikki