Wednesday, May 14, 2008

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