Right Outer Join/Right Join returns all the rows from the RIGHT table and the corresponding matching rows from the left table. SELECT *ĭemo 2: Below query demonstrates how to get the name of the Customer who don’t have Orders using LEFT OUTER JOIN. So the Left join on the CustomerId column between Customers and Orders table will return the Customer and Order details of the Customers with CustomerId 1 and 3 and for CustomerId 2 the Order Table columns will have NULL value in the result. Where as the customer with CustomerId 2 doesn’t have any order in the Orders table. If right table doesn’t have the matching record then for such records right table column will have NULL value in the result.ĭemo 1: As per the data in our demo tables, Customers with CustomerId 1 and 3 in Customers table have the orders in the Orders table. Left Outer Join/Left Join returns all the rows from the LEFT table and the corresponding matching rows from the right table. SELECT *ĭemo 2: Below Inner Join query demonstrates how to get name of all the Customer who have at-least one order in the Orders table. So the Inner Join on the CustomerId column between Customers and Orders table will return the Customer and Order details of the Customers with CustomerId 1 and 3 only. returns only those rows for which the join condition satisfies).ĭemo 1: As per the data in our demo tables, Customers with CustomerId 1 and 3 in Customers table have the orders in the Orders table. Inner Join returns only the matching rows in both the tables (i.e. Joining Two Tables without any Common Column between them 1. INSERT INTO Orders VALUES(300,3,Getdate()+1) INSERT INTO Orders VALUES(200,4,Getdate()) INSERT INTO Orders(OrderId, CustomerId, OrderDate)

(OrderId INT, CustomerId INT, OrderDate DateTime)

Create Orders Table and Insert records into it

INSERT INTO Customers(CustomerId, Name) VALUES(3,'Basavaraj') INSERT INTO Customers(CustomerId, Name) VALUES(2,'Kalpana') INSERT INTO Customers(CustomerId, Name) VALUES(1,'Shree') Create Customers Table and Insert records To demo these features let us first create the Customers and Orders table as depicted in the below image by using the following script: Join facilitates the retrieval of information from multiple tables. In Sql server we have following 6 types of Joins: Sql Server Tutorial Lesson 6: JOINS in Sql Server with Examples

Join two table in sql with null values