• 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!