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

DBMS specific notes
 Access: Replace DECIMAL(8,2) with MONEY

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

CREATE TABLE OrderItems
(
	order_num	INTEGER		NOT NULL,
	order_item	INTEGER		NOT NULL,
	prod_id		CHAR(10)	NOT NULL,
	quantity	INTEGER		NOT NULL,
	item_price	DECIMAL(8,2)	NOT NULL
);
