Select Code to Download

create table people (person_id integer not null primary key, surname v
+archar(40) not null)

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

surname                        town                                   
+  
------------------------------ ---------------------------------------
+- 
...
Jones                          NULL
Harry                          NULL
Peanut                         Cairns

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

surname                                  town                         
+            
---------------------------------------- -----------------------------
+----------- 
Smith                                    Bristol
Peanut                                   Cairns