View CUSTOMER

DMONIX

View CUSTOMER_ORDERS

Columns

Name	Type	Nullable	Default	Comments
CUSTOMER_NAME	NUMBER	N
PRODUCT_ID	NUMBER	N
DELIVERY_DATE	DATE	Y

SQL

SELECT c.id, p.id, o.delivery_date
 FROM dmonix.customer c, dmonix.products p, dmonix.orders o
 where c.id = o.customer_id
 and   p.id = o.product_id
 WITH READ ONLY