Left outer join

This example shows the data set that is output if you perform a left outer join on the Price key column.

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

Output Data Set
Status Price ID
sold 125 NI6325
sold 213  
offered 378  
Pending 575  
Pending 649  
Offered 777 JA1081
Offered 908 DE1911
Offered 908 FR2081
Pending 908 DE1911
Pending 908 FR2081