需要SQL从链接表中的关系表中选择一个表 [英] Need SQL to Select From one table with a relation ship in linking table

问题描述

我有桌子
(a)

I Have tables
(a)

ExerciseID      ExerciseName                    MuscleTarget    SetsReps
1               FreeHand Jump Squat             Quadriceps	2 sets of 15 reps
2               Dumbbel Lunges                  Quadriceps	3 sets of 8-10
3               Dumbbel Step ups                Quadriceps	3 sets of 8-10
4               Stiff-Legged Barbell Dead Lift  Hamstrings	3 sets of 8-10 reps
5               Lying Leg Curls                 Hamstrings	3 sets of 8-10 reps
6               Leg Extensions                  Hamstrings	3 sets of 8-10 reps
7               Leg Press                       Quadriceps	3 sets of 8-12 reps

还有
(b)

And
(b)

TrainingProgramID	ExerciseID	DayNumber
1	                7	        1
1	                8	        1
1	                9	        1
1	                10	        4
1	                11	        4
1	                12	        4

我需要Sql从表(a)中进行选择，其中表(b)中的DayNumber = 1
香港专业教育学院尝试:

I Need Sql to select from table (a) where in table (b) DayNumber =1
Ive tried :

SELECT DISTINCT Exercise.ExerciseName, Exercise.MuscleTarget, Exercise.SetsReps, TrainingProgramExercise.DayNumber
FROM Exercise, TrainingProgramExercise
WHERE TrainingProgramExercise.DayNumber = 1

也尝试了联接但不起作用
请帮助


[edit]已添加代码块-OriginalGriff [/edit]

Tried a join as well but not working
Please Help


[edit]Code blocks added - OriginalGriff[/edit]

推荐答案

您尝试过吗:

Did you try:

SELECT DISTINCT Exercise.ExerciseName, Exercise.MuscleTarget, Exercise.SetsReps, TrainingProgramExercise.DayNumber
FROM Exercise
INNER JOIN TrainingProgramExercise 
ON Exercise.ExerciseID = TrainingProgramExercise.ExerciseID
WHERE TrainingProgramExercise.DayNumber = 1

Did您可以尝试以下操作:

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

这篇关于需要SQL从链接表中的关系表中选择一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！