A LEFT OUTER JOIN in SQL: What Is It?

  • Comments posted to this topic are about the item A LEFT OUTER JOIN in SQL: What Is It?

  • This was removed by the editor as SPAM

  • Instead of repeatedly saying "two or more tables", I would phrase it as "two row sources".  The main benefit of this is to clarify that you are only ever considering two (possibly complex) rowsets for any join, whereas "two or more tables" opens up the possibility that there are some arcane interactions when using multiple tables, particularly when you have multiple outer joins.

    Also, your article doesn't mention what happens when there are multiple matching records returned by the right-hand source.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply