Exploring Exotic Joins

In addition to the joins we've examined so far, there are two specialized kinds of joins:

  • Self-joins

  • Outer joins

Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.