SQL problem

Det her:

select p.firstname,p.lastname,a.name
from crm5.associate as a
inner join crm5.person as p
on a.person_id = p.person_id
where a.deleted=0 and a.type=0
order by a.name

giver:
firstname      lastname        name
--------------------------------------
Michael        Hansen          MH
Søren          Jensen          SJ


MEDENS:
select a.name,p.firstname,p.lastname --bemærk a.name er flyttet
from crm5.associate as a
inner join crm5.person as p
on a.person_id = p.person_id
where a.deleted=0 and a.type=0
order by a.name

GIVER:
name
-----------------
MH
SJ

Hvorfor .. det ?