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

Reply via email to