posted 20 years ago
What flavor of database?
If DB2/UDB/SQLServer/Oracle 9i+:
select b.type_id, b.user_name
from all_user a left outer join selected_user b
on a.user_name = b.user_name
If Oracle 8 or lower:
select b.type_id, b.user_name
from all_user a, selected_user b
where a.user_name = b.user_name(+)
Other DBs should be similar...