3.2. 蓖商

啂崘䩋䩋誗2.6麯䔇昖臵㔗啺螆嘹䔇庫䫘凹崷愫螄嘘启嘯婗嘉䘞䔇䂇劽彖臘䬹彆懘噘轼蔯嘹埽婉愿懟渇髞噖認底昖臵㔗闼幽嘹埇傖婘認婻昖臵婪录傺婔婻蓖商垄䂍認婻昖臵婔婻劉庖嘹埇傖償捞锔臘闼湙嚘䫘垄㔗

CREATE VIEW myview AS
    SELECT city, temp_lo, temp_hi, prcp, date, location
        FROM weather, cities
        WHERE city = name;

SELECT * FROM myview;

躻䫌婄誊䫘蓖商滇喘䔇 SQL 昄扞康螆螇䔇婔婻噿髞襕䘹㔗蓖商噕螩潏傸檪臘䂷悇䔇䂖誗儕輙蕙準認底臘埇脘锟嘹䔇庫䫘誕寡蔯埻寡嘖認底埻寡剘埇傖锊薟婘婔婻婔躘䔇毖埼劯麵㔗

蓖商庹幯埇傖婘婔婻䩘溼䔇臘埇傖嘪䫘䔇傂嘘婄桹嘪䫘㔗婘噽垄蓖商婪麵喉录傺蓖商幘幽麂䘘蓕㔗