Select Code to Download

SELECT pt.surname, pt.town 
FROM (
...
  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 (
...
) t1,
  people
WHERE people.person_id = t1.person_id (+)