sql - How to insert multiple values into a Row if 1 field is distinct -

right have following data need insert table called locals want insert if street field not present in locals table. data , fields follows:

street    pc       locality ------------------------------ street1   abc xyz  street2   def xyz  b 

and on want insert locals table if street field not present in locals table.

i thinking of using following:

insert   locals (street,pc,locality)         (             select distinct s.street               locals_bk s              not exists (                       select 1                         locals l                        s.street = l.street                    )        )      ; 

but realize insert street field not rest of data on same row.

insert locals (street, pc, locality)  select b.street, b.pc, b.locality locals_bk b not exists (select * locals t t.street = b.street) 

or

insert locals (street, pc, locality)  select b.street, b.pc, b.locality locals_bk b b.street not in (select t.street locals t)