Database Reference
In-Depth Information
Figure 12.6
NOT EXISTS
with a Correlated
Subquery.
SELECT DISTINCT M.TITLE FROM MUSICCD M
JOIN CDTRACK CT ON (M.MUSICCD_ID = CT.MUSICCD_ID)
WHERE CT.SONG_ID = SOME
(SELECT SONG_ID FROM GUESTAPPEARANCE GA);
Figure 12.7
= ANY with a
Subquery.
