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

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

CREATE VIEW whole_db (c#,name,city,                      i#,date,qty,                      p#,pname,color,wt,price) AS  SELECT customer.c#,customer.name,customer.city,         invoice.i#,invoice.date,         litem.qty,         part.p#,part.pname,part.color,part.wt,part.price    FROM customer, invoice, litem, part   WHERE customer.c# = invoice.c#     AND invoice.i# = litem.i#     AND part.p# = litem.p#;