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

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

CREATE VIEW city_chg(city,total_last_yr,total_this_yr) AS
  SELECT y90.city, y90.total_sales, y91.total_sales
    FROM city_hist y90, city_hist y91
   WHERE y90.city = y91.city
     AND y90.yr = 1990
     AND y91.yr = 1991;