sqlite3 ，请教这个视图该如何写？

SQL code

-- 厂家表CREATE TABLE Vender (    Id   INTEGER     PRIMARY KEY AUTOINCREMENT,    Name CHAR( 32 )  NOT NULL                     UNIQUE,    Show BOOLEAN     NOT NULL                     DEFAULT ( TRUE ));-- 产品类型表CREATE TABLE ProductType (    Id   INTEGER     PRIMARY KEY AUTOINCREMENT,    Name CHAR( 32 )  NOT NULL                     UNIQUE);-- 产品表CREATE TABLE Product (    Id    INTEGER PRIMARY KEY AUTOINCREMENT,    V_Id  INTEGER NOT NULL                  REFERENCES Vender ( Id ) ON DELETE NO ACTION                                           ON UPDATE CASCADE,    PT_Id INTEGER NOT NULL                  REFERENCES ProductType ( Id ) ON DELETE NO ACTION                                                ON UPDATE CASCADE,    Show BOOLEAN  NOT NULL                  DEFAULT ( TRUE ),    UNIQUE ( V_Id, PT_Id ));-- 产品价格表CREATE TABLE ProductValue (    P_Id  INTEGER NOT NULL                  REFERENCES Product ( Id ) ON DELETE NO ACTION                                            ON UPDATE CASCADE,    Value NUMERIC NOT NULL,    Date  DATE    NOT NULL,    UNIQUE ( P_Id, Date ));

现在要一个视图显示
厂家名，产品类型名，最新报价，定价日期

[解决办法]
什么问题
[解决办法]
最近刚刚开始学习SQLITE3.
[解决办法]