How to find values without a FK?

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Wed, 3 Apr 2019 13:42:34 +0200
Message-ID: <q82679$dl1$1_at_gioia.aioe.org>

[Quoted] [Quoted] I got two tables to manage school's exams:

subjects

---

id_subject
name

users

---

id_user
name
FK_id_subject

The values of user's table are: "Tom, Peter, Sam"

The values of subject's table are: "Economics, Biology, Latin, History, Religion, German"

An user like Tom is linked by a FK to subjects "Economics, Biology, [Quoted] Latin" and it's easy to show which exams Tom passed but I need to show also which exams Tom should do in the future ("History, Religion, [Quoted] German"), how can I do it?

Regards.
^Bart Received on Wed Apr 03 2019 - 13:42:34 CEST