Re: How to find values without a FK?

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Wed, 3 Apr 2019 21:18:21 +0200
Message-ID: <q830ts$a4v$1_at_gioia.aioe.org>


> SELECT SUBJECT.NAME FROM
> ( SELECT * FROM PASSED
> INNER JOIN PERSON USING( PERSON )
> WHERE PERSON.NAME = 'TOM' ) AS TOM
> RIGHT JOIN SUBJECT USING( SUBJECT ) WHERE PERSON IS NULL;
Thanks, this is another idea about how to solve it! :)

^Bart Received on Wed Apr 03 2019 - 21:18:21 CEST

Original text of this message