I've come upon a problem in sqlite3. Here's the table:
CREATE TABLE contributors( contrib_id integer primary key, contrib_lname char not null, contrib_fname char, contrib_mname char, writer int, artist int, editor int) I've inserted several names. When I order by contrib_lname, contrib_fname I get the correct order, however when I say desc, I get the same order as without. It's only when I don't include the contrib_fname does it come out in last name order, however, there are a couple of entries with same last names but different first names and they won't necessarily sort properly if I don't include the contrib_fname column. Why am I not getting the results I'm expecting? Here are the commands: select * from contributors order by contrib_lname, contrib_fname; (works properly) select * from contributors order by contrib_lname, contrib_fname desc; (get the same order as above) select * from contributors order by contrib_lname desc; (this works but obviosiosly doesn't sub-order the contrib_fname) Mark _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users