declare @pspersonaldata table
(
	dcno 		int,
	fullname 	varchar(20),
	religion	varchar(20)
)
insert into @pspersonaldata
select	1, 'julie,angelina', 	'Born Again'		union all
select	2, 'Cage,Nicholas', 	'Roman Catholic'	union all
select	3, 'sample1', 		'Adventist'		union all
select	4, 'sample2', 		'Born Again'		union all
select	5, 'sample3', 		'Adventist'

declare @hremployees table
(
	empdcno 	int,
	Address 	varchar(10),
	telno		varchar(10)
)
insert into @hremployees
select	1, 'aaa', 111	union all
select	2, 'aaa', 222	union all
select	3, 'aaa', 333	union all
select	4, 'aaa', 444	union all
select	5, 'aaa', 555	union all
select	6, 'aaa', 666	union all
select	7, 'aaa', 777

select 	P.fullname, P.religion, E.empdcno 
from 		@pspersonaldata as P
inner join 	@hremployees 	as E on P.dcno = E.empdcno
where 	P.religion in ('Born Again', 'Adventist')
/*
fullname             religion             empdcno     
-------------------- -------------------- ----------- 
julie,angelina       Born Again           1
sample1              Adventist            3
sample2              Born Again           4
sample3              Adventist            5
*/