Re: [SQL] pesky select query

2000-10-03 Thread Tom Lane
"Ingram, Bryan" <[EMAIL PROTECTED]> writes: > What I'd like to do is produce a query that will > list each app_code and the count of distinct states for that app_code on one > line. I don't care what the state_code is, I just need to know the number > of distinct state_codes per app_code. > So f

[SQL] pesky select query

2000-10-03 Thread Ingram, Bryan
Hello .. I'm having trouble figuring out a good way to return my desired results from the following table ... Table= g_state_county_app app_code | varchar() not null state_code | int4 not null county_code