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

Power Virtual Agents: customize the bot conversation messages

Power Virtual Agents are an easily created powerful bot and no-code graphical interface without the need for data scientists or developers. ...

Subscribe to the FREE Weekly Newsletter to receive all the latest Microsoft Azure, AI, Xamarin

Popular Posts