Join two tables

HI All, 

I trying to bring together two tables in my report.

Table 1 (Tells us quantity of steel which currently in production) - For a single Order #, it has quantity/weight at different stations# in steelmaking process, e.g

Station A = 100 tons

Station B   = 200 tons ,etc.

Table 2 (It is an order book , contains all orders whether the production has started on order or not)  - Contains a single row information for the order # in table 1. The tabe has information like customer, length, width, customer name, total quantity ordered by the customer for the particular order #. So unlike Table 1 it will have the total quantity of an order (100+200+etc.)

Further, It will also have information including delivery date and quantity ordered on those orders which is yet to enter production.

What I want to achieve :

1. I want to append both the table such that entire table 1 is there and fetch those orders from table 2 which are not there in Table 1
2. Since table 1 does not have dimension details of the order, I need to fetch that information from table 2

I am badly confused how to join these tables and which table should be primary . Will it be better to create a new table altogether?

Model view

Thanks.