create table people (person_id integer not null primary key, surname varchar(40) not null)

insert into people values (1,'Smith')
insert into people values (2,'Jones')
insert into people values (3,'Harry')
insert into people values (4,'Peanut')

create table town (person_id integer not null references people(person_id), town varchar(40) null)

insert into town values (1,'Bristol')
insert into town values (2,'Washington')
insert into town values (3,NULL)
insert into town values (4,'Cairns')

    SELECT surname, town 
    FROM   people, town
    WHERE  people.person_id *= town.person_id
    AND    (town <> 'Washington' AND town IS NOT NULL)