Filter
Top Products
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;