Select multiple SQL tables for 1 while loop

[matthijs110]

Hello,

 

How can I select multiple SQL tables? For example like this:
 

$result = mysqli_query($con, "SELECT Username, Wins FROM Table1, Table2 ORDER BY Wins DESC");

I want to use it in 1:
 

while ($row = mysqli_fetch_assoc($result)) {

I know this is possible, but I can't find a clear way. 

[davidannis]

You need to use the mysql JOIN http://dev.mysql.com/doc/refman/5.0/en/join.html