[Solved] How can I quickly solve this query? [closed]

select a.name as name,b.name as represon from table1 a 
inner join table1 b on a.code=b.rperson