drop table contact;
drop table home;

create table contact(
  ID integer,
  LName varchar,
  FName varChar,
  Relationship varChar,
  HomeID integer
);


create table home(
  id integer,
  address varChar
);

Insert into home values(1, 'Noblesville');
insert into home values(2, 'Castleton');

insert into contact values (1,'Harris', 'Andy', 'me', 1);
insert into contact values (2,'Harris', 'Heather', 'wife', 1);
insert into contact values (3,'Harris', 'Elizabeth', 'daughter', 1);
insert into contact values (4,'Harris', 'Matthew', 'son', 1);
insert into contact values (5,'Moon', 'Judy', 'Mother in law', 2);
insert into contact values (6,'Moon', 'Chris', 'Brother in law', 2);

SELECT DISTINCTROW [contact].[FName], [home].[address]
FROM home INNER JOIN contact ON [home].[ID] =[contact].[homeID];