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;