> > > Assuming that is a typo, does the following not do what you want? > > SELECT table1.data1, table2.data2 > FROM > ( > SELECT table1.rowid, table1.data1 > WHERE table1.data1 = 10 > ORDER BY table1.rowid DESC > OFFSET 0 LIMIT 250 > ) AS table1 > JOIN table2 > ON table1.rowid = table2.rowid > ORDER BY table2.rowid; > > No, because it only sorts the current page. When the user scrolls down using the scrollbar, and the second page is fetched (OFFSET 250 LIMIT 250), it does not match up with the sorting of the previous page. Suppose it was sorted by a TEXT column of table2, it would look like this:
Page 1: aaa abb ddd Page 2: bba cca dda Maybe there is just no easy way to do what I want, I will take a good night sleep about it ;) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users