SQL JOIN | JOIN Syntax | JOIN Differences | Inner Join | Left Join | Right Join | Full Join

byAsp Dot Net Explorer -
0


What is a SQL join?

A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (i.e. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL is, and why someone would want to perform a SQL join.

Different Types of SQL JOINs

Here are the different types of the JOINs in SQL:


  • (INNER) JOIN: Returns records that have matching values in both tables.
  • LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from .the right table
  • RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table.
  • FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table.


#CSS#CascadingStyleSheet#AspDotNet #Mvc #WebForm #Sql
Tags

قد تُعجبك هذه المشاركات

إرسال تعليق

أحدث أقدم