我的桌子：
Table 1
excercises
| primaryMuscleGroup | motionName |
| ------------------ | -------------- ------|
| Chest | Dips |
| Chest | Chest Press |
| Chest | Push Up |
| Chest | Flye |
| Legs | Squat |
| Legs | Lunge |
| Back | Deadlift |
Table 2
fitnessRecords
| name | motionName |
| ------------------ | -------------- ------|
| John Smith | Dips |
| Sally | Squat |
| Wallace | Lunge |
| Christoph | Deadlift |
該查詢應該為一個人回傳他們尚未完成的肌肉群的所有鍛煉。例如，如果我們為客戶端“John Smith”運行查詢，我們應該回傳：
| primaryMuscleGroup | motionName |
| Legs | Squat |
| Legs | Lunge |
| Back | Deadlift |
如果我們為客戶端“Sally”運行查詢，我們應該回傳：
| primaryMuscleGroup | motionName |
| ------------------ | -------------- ------|
| Chest | Dips |
| Chest | Chest Press |
| Chest | Push Up |
| Chest | Flye |
| Back | Deadlift |
uj5u.com熱心網友回復：
SELECT *
FROM excercises t1
WHERE NOT EXISTS ( SELECT NULL
FROM fitnessRecords t2
JOIN excercises t3 USING (motionName)
WHERE t2.name = 'given name'
AND t1.primaryMuscleGroup = t3.primaryMuscleGroup )
https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=eb216b7579d5fcd0c0ab628717f3d676
uj5u.com熱心網友回復：
您可以使用外部聯接或使用not exists，看看是否需要以下內容：
select *
from exercises e
where not exists (
select * from exercises x
where exists (
select * from fitnessRecords fr
where fr.name = 'john smith' and fr.motionName = x.motionName
) and x.primaryMuscleGroup = e.primaryMuscleGroup
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/427760.html
上一篇：選擇具有下一行ID的行的問題
下一篇：帶連接的Athena查詢