�@



va
When the in stock number is equal to or below this amount, the product must be reordered.
7

69999969
6



orditems.dbf
Order detail items
J5
Number of units of this product are on order.
7

69999999999


D�'�'��@ʬ@T�M�_���('








.
customer
cust_id

cust_id


,
employee
emp_id

emp_id


.
orders
order_id

order_id


4
products
product_id

product_id










7�e�΅G�9�Qx���q�P2Ά�β��P\���i|�d�H���


.

0
$

(
,
P
Q

R
/�
%d
'�����

*SELECT * FROM  testdata!customer INNER JOIN testdata!orders    INNER JOIN testdata!orditems    INNER JOIN testdata!products    ON  Orditems.product_id = Products.product_id    ON  Orders.order_id = Orditems.order_id    ON  Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date   AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id
)



+
�D$LPS�����
�D$�H�
�|
�F �
+
&
-
#discontinu	
ML		CustomActio
-
&
-
#cust_id_a
MC(6) 111"
22	n
,
&
-
#company

MC(40)ical install
,
&
-
#contact

MC(30)ustomDlg	33 
*
&
-

#title

MC(30)rs with minimu
,
&
-
#address

MC(60)dll, 113"
2
)
&
-
#city

MC(15)alled to run fr
+
&
-
#region

MC(15)

25				Cust
1
&
-
#postalcode_a

MC(10)schdpl3
,
&
-
#country

MC(15)es
27	yes	S
*
&
-

#phone

MC(24)ion Shared		Op
(
&
-
#fax

MC(24)eSharedMode
30	
4
&
-
#maxordamt
MY NOCPTRANSAppl
.
&
-
#order_id_a
MC(6)nge	Micros
-
&
-
#cust_id_b
MC(6)aging messa
*
&
-
#emp_id
MC(6)yes
32	yes	Sc
,
&
-
#to_name

MC(40) Time and In
/
&
-
#to_address

MC(60)92 		vita
,
&
-
#to_city

MC(15)r for sendin
.
&
-
#to_region

MC(15)ionDlg	37 
1
&
-
#postalcode_b

MC(10)e's Sch
/
&
-
#to_country

MC(15)ols.	Opti
/
&
-
#ship_count

MC(15)change		G
,
&
-
#ship_via
MC(6)yes	%25

3
+
&
-
#order_date	
MDgram	Group	45
4
&
-
#order_amt
MY NOCPTRANSes c
-
&
-
#order_dsc
MN(3)ms.	OptionD
4
&
-
#order_net
MY NOCPTRANSows 
+
&
-
#require_by	
MD%h\Proof
40	
+
&
-
#shipped_on	
MDoup	371 				n
2
&
-
#freight
MY NOCPTRANSrogram
+
&
-
#line_no
MN(5)vices	These s
.
&
-
#order_id_b
MC(6)of systems
0
&
-
#product_id_a
MC(6)g	Allows
7
&
-
#unit_price_a
MY NOCPTRANS4
/
&
-
#quantity
MN(12,3)	371 				
0
&
-
#product_id_b
MC(6)
46		Mic
.
&
-
#prod_name

MC(40)ion	MSMAIL
-
&
-
#eng_name

MC(40)	StampCDInf
/
&
-
#no_in_unit

MC(20)53
51			
7
&
-
#unit_price_b
MY NOCPTRANSL
4
&
-
#unit_cost
MY NOCPTRANSt"""
/
&
-
#in_stock
MN(12,3)Files				
/
&
-
#on_order
MN(12,3)etConfigI
1
&
-
#reorder_at
MN(12,3)? 58
5
>
&
-
!
#testdata!customer.country

MC(15)q

.

0
$

(
,
P
<
&
-

#testdata!customer.title

MC(30)40)�6����X�I"�n�-@_2+���Ckڄ�I�VzLb���ں!�SA�ն*��.�W�9�r
>
&
-
!
#testdata!customer.contact

MC(30)#
&
-
MY NOCPTRANSI���$iN���ը����
>
&
-
!
#testdata!customer.company

MC(40)3
&
-#
#testdata!products.prod_name����
=
&

-!
#testdata!customer.cust_id
MC(6) Orditems.quantity) FROM  testdata!products INNER JOIN test

9

.

0
$

(
,
P
Q

R
/�
%d
'����
+testdata!customer�
*SELECT Customer.cust_id, Customer.company, Customer.contact,  Customer.title, Customer.country FROM testdata!customer WHERE Customer.country = ?whichcountry
)




v

.

0
$

(
,
P
G



customer.dbf
cust_id
Customer information
cc
Unique Customer ID code made up of the first five character of the Customer's Company name.
**
Primary contact for this Customer.
SS
Region of the country the Customer lives in; For the US, this is the State.
DD
Postalcode of the Customer; For the US, this is the Zipcode.
	
7$
6999999.99
F



employee.dbf
emp_id
Employee information Employees.
##
Unique numeric Employee ID.
SS
Region of the country the Employee lives in; For the US, this is the state.
DD
Postalcode of the Employee; For the US, this is the Zipcode.
::
Employee ID of the direct report of this Employee.
;;
Embedded bitmap of a current photo of the Employee.
A



orders.dbf
order_id
Customer orders
!!
Unique ID for this Order. Order.
ZZ
Customer ID of the Customer of this Order; Links this table to the Customer table.
TT
Employee ID of the Employee who made this sale; Links to the Employee table.
aa
Specifies the Ship To name when shipping an order, if different from purchasing Customer.L$�ƒ��;����֋L$�
nn
Specifies the Ship To address when shipping an order, if different from purchasing Customer's address.
hh
Specifies the Ship To city when shipping an order, if different from purchasing Customer's city.
��
Specifies the Ship To region when shipping an order, if different from purchasing Customer's region.  In the US, this is the state.
��
Specifies the Ship To postalcode when shipping an order, if different from purchasing Customer's postalcode.  In the US, this is the Zipcode.
nn
Specifies the Ship To country when shipping an order, if different from purchasing Customer's country.
II
Specifies the ship method when sending the order to the customer.
J0
Amount Product is sold to Customers for.
6999999.99	
7$
##
Unique ID for this Product.
BB
Specifies the date the Customer must receive the order by.
44
Specifies the date the order was shipped on.
4(
Quantity of the product ordered.
69999
P6
Total amount of the order before the discount.
6999999.99	
7$
E2
Discount percentage given to the Customer.
7
699%9%
G-
Total of the order less the discount.
6999999.99	
7$
C)
Total cost of shipping the order.
6999999.99	
7$
33
Order ID number; Links to the Orders table.
GG
Product ID of the product ordered; Links to the Products table.
T:
Unit price of the product at the time of the sale.
6999999.99	
7$
W



products.dbf
product_id)
Product and Inventory information
==
Specifies whether this Product has been discontinued.
DD
Description of number of items in each unit of this Product.
T:
Amount Product is purchased for sale to Customers.
6999999.99	
7$
I;
Number of units of this product currently in stock.
6999999