Here is an example of how that could be achieved
--demo setup
Declare @Table1 table (id int, name varchar(20), lastname varchar(20), imageshortpath varchar(100), imagefullpath varchar(100))
insert into @Table1(id, name, lastname, imageshortpath, imagefullpath) values
(2108,'mudasir', 'khan','imageshortpath','imagefullpath')
Declare @Table2 table (id int, peopleid int, address varchar(20))
insert into @Table2(id, peopleid,address) values
(1,2108,'hyderabad'),(2,2108,'larkana')
--solution
select t1.*,
STUFF((
SELECT ',' + address
FROM @Table2 t2
WHERE t2.peopleid = t1.id
FOR XML PATH('')
), 1, 1, '') AS Address
from
@Table1 t1
| id | name | lastname | imageshortpath | imagefullpath | Address |
|------|---------|----------|----------------|---------------|-------------------|
| 2108 | mudasir | khan | imageshortpath | imagefullpath | hyderabad,larkana |
Check out this excellent answer about How Stuff and 'For Xml Path' work in Sql Server.