Full outer join

Here is the data set that is output if you perform a full outer join.

Here is the data set that is output if you perform a full outer join on the Price key column:

Table 1. Output data set
Status Price Price ID
    113 NI6325
sold 125 125 BR9658
sold 213    
    285 CZ2538
offered 378    
Pending 575    
    628 RU5713
Pending 649    
    668 SA5680
Status Price Price ID
Offered 777 777 JA1081
Offered 908 908 DE1911
Offered 908 908 FR2081
Pending 908 908 DE1911
Pending 908 908 FR2081