Category : Files from Magazines
Archive   : DBMS0291.ZIP
Filename : GERRIT3.FEB

 
Output of file : GERRIT3.FEB contained in archive : DBMS0291.ZIP

Listing 3

SELECT i#, idate FROM invoice
WHERE c# IN (SELECT c# FROM customer
WHERE name = 'Jones')

SELECT i#, idate FROM invoice
WHERE c# = ANY (SELECT c# FROM customer
WHERE name = 'Jones')