Rick Guizawa wrote:
> 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 pro
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
> 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 colum
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
> Dear Friends, please help with sqlite query, i have a table like
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
4 matches
Mail list logo
