As per the request above, please see:

create table Reference(referencenumber int primary key identity(1,1),lastname varchar(20),firstname varchar(20))

create table [Address](addressid int primary key identity(1,1),referencenumber int references reference(referencenumber),address1 varchar(20),

city varchar(20),state varchar(2),country char(2),zipcode varchar(20))

go

insert into reference values('lincoln','sam'),('wright','mike'),('lincoln','will'),('lincoln','sam'),('lincoln','sam')

go

insert into [Address] values(1,'east avenue','atlanta','GA','US',12345),

(2,'south avenue','atlanta','GA','US',12345),

(3,'west avenue','atlanta','GA','US',12345),

(4,'east avenue','atlanta','GA','US',12345),

(5,'east avenue','atlanta','GA','US',12345)

So basically in my query I would only want to see reference numbers 4 and 5. Basically surname, address 1, zip code should = but the reference number should be <> , not =.

I hope this is clearer and that the test data is workable.