Create table  person
(
PersonId int primary key identity(1,1) not null,
FirstName varchar(255) not null,
LastName varchar(255) not null,
)

Create table Address
(
AddressId int primary key identity(1,1) not null,
personId int not null,
City varchar(255) not null,
[state] varchar(255) not null
)
insert into Person(FirstName,LastName) values('Wang','Allen')
 insert into [Address](PersonId,City,[State]) values('2','New York City','New YORk')

 select p.FirstName,p.LastName,A.City,A.[state]from Person as P join   Address as A on P.PersonId=A.personId;