Did you try something like:
SELECT Exercise.ExerciseName,
Exercise.MuscleTarget,
Exercise.SetsReps,
TrainingProgramExercise.DayNumber
FROM Exercise,
TrainingProgramExercise
WHERE TrainingProgramExercise.DayNumber = 1
AND Excercise.ExerciseID = TrainingProgramExercise.ExcerciseID