What is a join and List different types of joins

Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.

Types of joins:

  • INNER JOINs,
  • OUTER JOINs,
  • CROSS JOINs.
  • OUTER JOINs are further classified as
  • LEFT OUTER JOINS,
  • RIGHT OUTER JOINS and
  • FULL OUTER JOINS.

0 Comments

Featured Post

How to Get an Free Azure Subscription for Learning

This guide will help you get started with Microsoft Azure for free. It explains three easy ways: using a Free Azure Account Signing up for A...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts