Hi,
Create table table1(id1 int,id2 int,address1 varchar(100),address2 varchar(100))
insert into table1
values(1,3,'e','f'),(1,5,'i','j'),(1,6,'k','l')
create table table2(id1 int,id2 int,[address] varchar(100))
insert into table2(id1,id2)
values(1,1),(1,2),(1,3),(1,4),(1,5),(1,6),(1,7)
select * from table1
select * from table2
Desired query result:
id1 id2 address
1 1 e
1 2 e
1 3 f
1 4 i
1 5 j
1 6 l
1 7 k
I would be very thankful if any one can help me with above output. Thanks in advance.
Thanks & Best Regards,
Sreeram.