SQL: inner join

select distinct last_name, first_name, login_name, login_password, email from user

inner join administrator on user.id = administrator.user_id

order by Last_Name