[RESOLVED] [MySQL] Data from 2 tables ORDER BY issue

[PeejAvery]

I want to get data from 2 tables...easy! Works as it should.

SELECT mam01_user.*, (SELECT nick FROM mam01_nicks WHERE user = mam01_user.id ORDER BY id DESC LIMIT 1) AS player FROM mam01_user, mam01_nicks LIMIT 10

However, when I go to order it...I get 10 identical rows of information.

SELECT mam01_user.*, (SELECT nick FROM mam01_nicks WHERE user = mam01_user.id ORDER BY id DESC LIMIT 1) AS player FROM mam01_user, mam01_nicks ORDER BY mam01_user.lastseen DESC LIMIT 10

What am I doing wrong?

[PeejAvery]

Nevermind. I ended up doing a LEFT JOIN instead.

SELECT * FROM mam01_user LEFT JOIN mam01_nicks ON mam01_user.id = mam01_nicks.user ORDER BY mam01_user.lastseen DESC LIMIT 10