==========================================================
Sams Teach Yourself SQL in 10 Minutes - ISBN 0672316641
Appendix A - Sample Table Scripts
Populate OrderItems table

Note: Depending on the client software being used, you may
have to execute these INSERT statements one at a time.

DBMS specific notes
 None

Important: When using this SQL statement only include
text beneath the lines below.
==========================================================

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20005,1,'BR01',100,5.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20005,2,'BR03',100,10.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20006,1,'BR01',20,5.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20006,2,'BR02',10,8.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20006,3,'BR03',10,11.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20007,1,'BR03',50,11.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20007,2,'BNBG01',100,2.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20007,3,'BNBG02',100,2.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20007,4,'BNBG03',100,2.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20007,5,'RGAN01',50,4.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20008,1,'RGAN01',5,4.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20008,2,'BR03',5,11.99);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20008,3,'BNBG01',10,3.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20008,4,'BNBG02',10,3.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20008,5,'BNBG03',10,3.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20009,1,'BNBG01',250,2.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20009,2,'BNBG02',250,2.49);

INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
VALUES(20009,3,'BNBG03',250,2.49);
