I would like to join two tables but couldn't find any existing joins(I tried left, right, full, cross) to do that.
I want to combine table 1 and table 2 into the table 3. 
The data order was based on chronological order, and I would like to see the same order in desired table.

TABLE 1:

Student---- Score1  

A------------ 90  

A------------ 80  

B------------ 85  

B------------ 60  

C------------ 50  

C------------ 40

Table2:

Student---- Score2  

A------------ 66  

A------------ 70  

A------------ 85  

B------------ 60  

C------------ 40

Table 3: Desired Table

Student---- Score1-----Score2  

A------------ 90 ----------- 66  

A------------ 80 ----------- 70  

A------------null -----------85  

B------------ 85 ----------- 60  

B------------ 60 ----------- null  

C------------ 50 ----------- 40  

C------------ 40 ----------- null 

Thank you!