home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9103.ZIP / SQL4.MAR < prev    next >
Encoding:
Text File  |  1991-01-22  |  420 b   |  2 lines
  1.  
  2. CREATE VIEW whole_db (c#,name,city,
  3.                       i#,date,qty,
  4.                       p#,pname,color,wt,price) AS
  5.   SELECT customer.c#,customer.name,customer.city,
  6.          invoice.i#,invoice.date,
  7.          litem.qty,
  8.          part.p#,part.pname,part.color,part.wt,part.price
  9.     FROM customer, invoice, litem, part
  10.    WHERE customer.c# = invoice.c#
  11.      AND invoice.i# = litem.i#
  12.      AND part.p# = litem.p#;
  13.