SELECT pt.surname, pt.town FROM ( select people.surname, town.town from people, town where people.person_id = town.person_id (+) ) pt WHERE pt.town <> 'Washington' AND pt.town IS NOT NULL #### insert into people ( person_id, surname ) values ( 5, 'Drifter' ) #### SELECT people.surname, t1.town FROM ( select * from town where town <> 'Washington' AND town IS NOT NULL ) t1, people WHERE people.person_id = t1.person_id (+)