This article is now incorporated into the DP4 SQL Products manual. You can find the information that was formerly here at SQL Joins, though some has also been moved to SQL Implementation