Black Box 4/BlackBox.cdr/proglang/dbms9102.arj/GERRIT4.FEB

Text File | 1990-12-18 | 246b | 10 lines

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;