declare @BodyPart table(PartId int Identity(1,1),Part varchar(50))
declare @Workout table(WorkoutId int Identity(1,1) ,PartID int,Workout varchar(50))
insert into @BodyPart(Part)
select 'Arms' Union All
select 'Back' Union All
select 'Chest' Union All
select 'Legs' 

insert into @Workout(PartID,Workout)
select 1,'Curls' Union All
select 1,'Tricep Extensions' Union All
select 2,'Military Press' Union All
select 2,'Shoulder Shrugs' Union All
select 3,'Push Ups' Union All
select 3,'Bench Press' Union All
select 4,'Leg Press' Union All
select 4,'Squats' 

Select a.Part,b.Workout
from 
	@BodyPart a
Inner Join
	(	
		Select Row_Number() over ( Partition by PartID order by newid()) as rowID,*
		from	
			@Workout
	) b
on a.PartID = b.PartID
where b.RowID = 1