We walk in the dark places no others will enter
We stand on the bridge and no one may pass

create table #Parent
(
	ParentID int identity,
	SomeValue varchar(10)
)

create table #Child
(
	ChildID int identity,
	ParentID int,
	SomeValue varchar(10)
)

insert #Parent
select 'Parent 1' union all
select 'Parent 2'

insert #Child
select 1, 'Child 1' union all
select 1, 'Child 2' union all
select 2, 'Child 3' union all
select 2, 'Child 4' union all
select 2, 'Child 5'

select * 
from #Parent p
join #Child c on p.ParentID = c.ParentID

drop table #Parent
drop table #Child