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

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


Listing 4

SELECT pname, price, qty, customer.name
FROM part, litem, invoice customer
WHERE part.p# = litem.p#
AND litem.i# = invoice.i#
AND invoice.c# = customer.c#
AND qty > 5;