Database Reference
In-Depth Information
Figure 12.10
The WHERE
Clause Contains a
Multiple-Column
Subquery.
SELECT A.ARTIST_ID, A.NAME, S.TITLE FROM SONG S,
(SELECT ARTIST_ID, NAME
FROM ARTIST WHERE NAME LIKE '%u%') A
WHERE A.ARTIST_ID = S.ARTIST_ID;
Figure 12.11
The FROM Clause
Contains a
Multiple-Column
Subquery.
