将多个表插入到一个表中

 Http://i.stack.imgur.com/z0fSP.png
 Http://i.stack.imgur.com/Nd3nB.png
 Http://i.stack.imgur.com/5qtRh.png
 Http://i.stack.imgur.com/01PVc.png
 Http://i.stack.imgur.com/wvibY.png



 INSERT INTO  OrderArchive                               

    (OrderNumber,OrderDate,StockItem,Quantity,UnitPrice,SalesRep,Customer,ArchiveDate)     
    SELECT "ORDER".OrderNo,
    "ORDER".OrderDate,
    Stock.StockNo||' '||Stock.StockDesc,
    Orderline.Quantity,
    Orderline.UnitPrice,
    Person.FirstName||' '||Person.Surname,
    Person.FirstName||' '||Person.Surname,
    OrderArchive.ArchiveDate
    FROM "ORDER"
    INNER JOIN Stock
        ON Stock.StockNo||' '||Stock.StockDesc = OrderAchive.StockItem
    INNER JOIN Orderline
        ON Orderline.Quantity = OrderArchive.Quantity
    INNER JOIN Orderline
        ON Orderline.UnitPrice = OrderArchive.UnitPrice
    INNER JOIN Person
        ON Person.FirstName||' '||Person.Surname = OrderArchive.SalesRep
    INNER JOIN Person       
        ON Person.FirstName||' '||Person.Surname = OrderArchive.Customer 
    WHERE "ORDER".OrderDate  < DATEADD('M',6,SYSDATE); 
 Http://i.stack.imgur.com/z0fSP.png
 Http://i.s