What is a join and List different types of joins

Posted by Suthahar on Friday, January 21, 2011 No comments

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.

Tags

Suthahar Jegatheesan is Mobile and Cloud Specialist/Architect and he has 15+ years of IT experience as a Technology Consultant /Programmer/Developer in IT industry. Suthahar is an industry luminary focused on AI, Computer Vision, Bot, Machine Learning, UWP, Azure, Xamarin and Web Emerging User Experiences as subject matter expert (SME) in implementation, architecture, development and administration.
Facebook
Google+
Linkedin
Pinterest
Delicious

0 Comments

Featured Post

How to Get an Free Azure Subscription for Learning

Whether you're a student, beginner, or professional looking to upskill with Microsoft Azure, here are 3 ways to get started with zero ...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts