SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Sample Database
HP NonStop SQL/MX Reference Manual—523725-004
D-12
PARTSUPP Table
x.partnum = p.partnum
AND
x.suppnum = s.suppnum;
This statement creates the VIEW207N view:
CREATE VIEW view207n (
partnumber
,partdescrpt
,suppnumber
,supplrname
,partprice
,qtyreceived
)
AS SELECT
x.partnum
,p.partdesc
,s.suppnum
,s.suppname
,x.partcost
,x.qty_received
FROM
samdbcat.invent.supplier s LEFT JOIN
samdbcat.invent.partsupp x
ON s.suppnum = x.suppnum
LEFT JOIN samdbcat.sales.parts p
ON x.partnum = p.partnum;
This statement creates the VIEWCUST view:
CREATE VIEW viewcust (
custnumber
,cusname
,ordernum
)
AS SELECT
c.custnum
,c.custname
,o.ordernum
FROM
samdbcat.sales.customer c LEFT JOIN
samdbcat.salesorders o
ON c.custnum = o.custnum;
This statement creates the VIEWCS view:
CREATE VIEW samdbcat.invent.viewcs
AS SELECT
custname
FROM samdbcat.sales.customer
UNION
SELECT
suppname
FROM samdbcat.invent.supplier;