Guess that's why I couldn't find any results when searching for "conditional join".