dwain.c (11/12/2013)
Exotic JOIN? I think BOL must have forgotten to mention that one. 😛
yeah the whole "exotic' naming convention for non traditional joins started back in 2007 with a series of articles here on SSC:
i read it, so i kinda remember it.
Using Exotic Joins in SQL Part 1[/url]
Using Exotic Joins in SQL - Part 2[/url]
Exotic Joins in T-SQL and How They Translate in SSIS[/url]
Lowell