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 <[email protected]> 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
> [email protected]
> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
