two mysql tables
#1

Hi,

I have two tables:

Код:
players
and

Код:
players1
And i want to get players which have the most XP, but i want to order that from both tables, how to make that querie?

Because if i do for ex for players table

Код:
SELECT XP FROM players ORDER BY XP DESC LIMIT 10
I tried

Код:
SELECT XP FROM players,players1 ORDER BY XP DESC LIMIT 10
But this don't work.
Reply


Messages In This Thread
two mysql tables - by audriuxxx - 17.03.2014, 15:20
Re: two mysql tables - by Thomaske - 17.03.2014, 23:21
Re: two mysql tables - by VishvaJeet - 18.03.2014, 04:10
Re: two mysql tables - by CuervO - 18.03.2014, 04:42

Forum Jump:


Users browsing this thread: 1 Guest(s)