[Thomaske]

Try something like this:

PHP код:

select `YourDBName`.`players`.`username` AS `username`,`YourDBName`.`players`.`xp` AS `xp` from `YourDBName`.`players` 
union 
select `YourDBName`.`players1`.`username` AS `username`,`YourDBName`.`players1`.`xp` AS `xp` from `YourDBName`.`players1` 
order by `xp` desc 


the best was if to create a view in your database of a table and use this query, then it is always logged in the view.

the query is ceated to put the highest score on top.

if this helped you +rep.

if you need more information let me know.