Displaying Null values in relationship

All, 

I have two tables

Table 1

Location

Table 2 

Location, Value, 

Now I want to create a table matrix that includes ALL locations in Table 1 + Table 2. 

If table 2 does not have a location to match table 1. The row should look like this.

Location1               Location2                Value

New York                 (blank)                  (blank) 

I created a Many to Many relationship but this is not showing NULL values.