ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng)/ProfitPress-MegaCDROM2.B6I/MAGAZINE/MISC/DBMS9103.ZIP/SQL2.MAR

Text File | 1991-01-22 | 314 b | 2 lines

CREATE VIEW complete_order(c#,name,i#,date,order_value) AS
  SELECT customer.c#,customer.name,invoice.i#,invoice.date
         SUM(part.price*litem.qty)
    FROM part, litem, invoice, customer
   WHERE part.p# = litem.p#
     AND litem.i# = invoice.i#
     AND invoice.c# = customer.c#
   GROUP BY 1, 2, 3, 4;