HP c-tree-SQL ISQL and Tools User Manual download pdf (Page 95)

Tutorial Source Code

FairCom Corporation A-5

ROLLBACK WORK;

INSERT INTO orderitems VALUES ('3', 1, 2, '3');

INSERT INTO orderitems VALUES ('3', 2, 3, '99');

INSERT INTO orderlist VALUES ('9/22/2002', '9/26/2002', '3', '1002');

SELECT orderitems.oi_itemnum, itemmast.im_itemnum

FROM orderitems, itemmast

WHERE orderitems.oi_itemnum = itemmast.im_itemnum;

SELECT orderlist.ol_custnum, custmast.cm_custnum

FROM orderlist, custmast

WHERE orderlist.ol_custnum = custmast.cm_custnum;

ROLLBACK WORK;

SELECT * FROM orderlist;

SELECT * FROM orderitems;

1 2 ... 90 91 92 93 94 95 96 97 98 99

Comments to this Manuals

No comments