See this topic http://www.w3schools.com/sql/sql_join.asp for more information =S and sry about my english =D
2012/10/29 Caio Honma <[email protected]> > prob. u want something like "SELECT t1.score, t1.rank, t2.subrank, t1.game > FROM table1 t1 LEFT JOIN table2 t2 ON t1.game = t2.game (if game is the > common column on both tables else use the common element) > > > 2012/10/29 Rick Guizawa <[email protected]> > >> Dear Friends, please help with sqlite query, i have a table like: >> >> score| rank | game >> 98 | 1 | 1615 >> 98 | 1 | 1615 >> 92 | 2 | 1615 >> 87 | 3 | 1615 >> 87 | 3 | 1615 >> 87 | 3 | 1615 >> 112 | 1 | 1616 >> 94 | 2 | 1616 >> 94 | 2 | 1616 >> >> I want to have a query to produce : >> >> score | rank | subrank | game >> 98 | 1 | 1 | 1615 >> 98 | 1 | 2 | 1615 >> 92 | 2 | 1 | 1615 >> 87 | 3 | 1 | 1615 >> 87 | 3 | 2 | 1615 >> 87 | 3 | 3 | 1615 >> 112 | 1 | 1 | 1616 >> 94 | 2 | 1 | 1616 >> 94 | 2 | 2 | 1616 >> >> Thank's in advance for your help. >> Ricky >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
