home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9104.ZIP / SQL1.APR < prev    next >
Encoding:
Text File  |  1991-03-01  |  210 b   |  7 lines
  1.  
  2. CREATE VIEW customer (c#, name, city) AS
  3.  SELECT customer_name.c#, name, customer_site.city
  4.    FROM customer_name, customer_site
  5.   WHERE customer_name.c# = customer_site.c#
  6.     AND customer_site.type = `HQ';
  7.