Join Operator Figure Pg 928
The image known as Figure 19-5 on page 928.
The example, shows the combining of two tables "Products Table" and "Orders Table" using the 'Product ID''s of each table as the joining condition.
The bottom table should of been written as follows:
PRODUCT_ID, NAME , UNIT_PRICE, ORDER_ID, PRODUCT_ID, CUSTOMER_ID, QUANTITY
10002 , bread, 0.50 , 20001 , 10002 , VEAD , 50
10002 , bread, 0.50 , 20003 , 10002 , VEAD , 30
10003 , cake , 0.30 , 20002 , 10003 , TOMS , 40
Hope this helps anyone who gets confused.
|
