Neoview Guide to Stored Procedures in Java (R2.5)

,partprice
,qtyreceived
)
AS SELECT
x.partnum
,partdesc
,x.suppnum
,suppname
,partcost
,qty_received
FROM
invent.partsupp x
,sales.parts p
,invent.supplier s
WHERE
x.partnum = p.partnum
AND
x.suppnum = s.suppnum;
CREATE VIEW invent.view207n (
partnumber
,partdescrpt
,suppnumber
,supplrname
,partprice
,qtyreceived
)
AS SELECT
x.partnum
,p.partdesc
,s.suppnum
,s.suppname
,x.partcost
,x.qty_received
FROM
invent.supplier s LEFT JOIN invent.partsupp x
ON s.suppnum = x.suppnum
LEFT JOIN sales.parts p
ON x.partnum = p.partnum;
CREATE VIEW invent.viewcust (
custnumber
,cusname
,ordernum
)
AS SELECT
c.custnum
,c.custname
,o.ordernum
FROM
sales.customer c LEFT JOIN sales.orders o
ON c.custnum = o.custnum;
CREATE VIEW invent.viewcs
AS SELECT
custname
FROM sales.customer
UNION
SELECT
suppname
FROM invent.supplier;
INSERT INTO invent.partsupp
VALUES ( 212, 1, 2000.00, 20 ),
( 212, 3, 1900.00, 35 ),
INVENT Schema 115