Query Question

[axman505]

I have a database that has an auto incrementing id as primary key, along with address, city, state, etc.

I need a query to select city, state but only distinct ones. There may be duplicates, and a given city may exist in more than one state.

Is this doable?

 

[r937]

select distinct city,state from yourtable

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[axman505]

that was not workign right before, ill give it another try.

 

[Bastien]

only one distinct clause allowed per query

Bastien

Cat, the other other white meat

 

[Bastien]

depedning on your data needs, perhaps a union might work

Bastien

Cat, the other other white meat

 

[r937]

axman, if the same city occurs in more than one state, please tell me you want both of them

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)