select top 10 * from dailyRankingTable union all
SELECT a.* FROM dailyRankingTable a, friendTable b WHERE upper(b.player) = upper('?') AND upper(b.friend) = upper(a.name) Top 10 does not work for SQlite I believe. But you might can find something like it. /Andreas On Mon, May 10, 2010 at 11:18 AM, Ian Hardingham <i...@omroth.com> wrote: > Hey guys. > > I have the following query: > > SELECT a.* FROM dailyRankingTable a, friendTable b WHERE upper(b.player) > = upper('?') AND upper(b.friend) = upper(a.name) > > (ignore the uppers for now - I'm going to refactor soon) > > I would like this query to also select the first 10 elements of > dailyRankingTable regardless - is that possible in one select? > > Thanks, > Ian > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Andreas Henningsson "Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users