Now, this SQL works, but the problem is that it only returns those locations that have a location type assigned. I want to return all records, even if they don't have a location type assigned. I tried ...