On Tue, 14 Sep 2010, Paul Corke wrote: > What do you get from: > > select distinct state from companies;
Paul, sqlite> select distinct state from Companies; 'ID' 'NV' 'OR' 'UT' 'WA' That's why this inability to use the WHERE clause completely escapes my understanding. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
