> Also, I agree with Simon that the query itself, and it's use of NULL, looks > weird. And I don't see where it could find any matches because the "ON > work.fpath = home.fpath" should never match if either fpath is NULL. > > I confess, I understand basic SQL but it is not one of my strengths at all. I found an example of this query via Google, tried it, and it worked. I manually manipulated the data source to generate matches based on the criteria I was looking for. The results were completely as expected.
I am more than open to a more logical and/or more efficient query if anyone has suggestions.
