select s.main,a.name,s.backup,b.name from support s, names a, names b where s.main=a.key and s.backup=b.key; Main Name Backup Name ---- ------ ------ ----- 10 Bob 72 Sally 106 Amanda 73 Jose
select s.main,a.name,s.backup,b.name from support s, names a, names b where s.main=a.key and s.backup=b.key; Main Name Backup Name ---- ------ ------ ----- 10 Bob 72 Sally 106 Amanda 73 Jose