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

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

CREATE VIEW canadian_values (c#, name, i#, order_value) AS
  SELECT c#, name, i#, order_value * currency.rate
    FROM complete_order, currency
   WHERE currency.country = 'Canada';