Posted inphp / Mysql / Mysqli

sql left outer join

Today, We want to share with you sql left outer join.In this post we will show you left outer join vs left join, hear for sql left join we will give you demo and example for implement.In this post, we will learn about sql left join multiple tables with an example.

SQL OUTER JOIN – Left Join

In this tutorial we learn to all about having Examples like as a Left Join, Left Outer Join, conditions in ON vs. WHERE clause, ISO/ANSI LEFT OUTER JOIN queries, SQL Server Left Outer Join or many more.

Also Read:

LEFT OUTER JOIN – fetches data if present in the left table.

Syntax for Left Outer Join

SELECT column-name-list FROM 
table-name1 LEFT OUTER JOIN table-name2
ON table-name1.column-name = table-name2.column-name;
SELECT * FROM class LEFT OUTER JOIN class_info ON (class.id = class_info.id);

SQL OUTER JOIN – left outer join

SELECT c.shopperid, 
       c.factoryName,
       requestid
FROM shoppers c
LEFT JOIN requests o ON o.shopperid = c.shopperid
ORDER BY requestid

SQL Server LEFT JOIN: conditions in ON vs. WHERE clause

SELECT
    mobile_name,
    request_id
FROM
    mobileion.mobiles p
LEFT JOIN sales.request_items o 
   ON o.mobile_id = p.mobile_id
WHERE request_id = 100
ORDER BY
    request_id;

USE SQL LEFT JOIN :

SELECT pupilable1. Pupil_name, pupilable1.State, pupilable2. Branch, pupilable2.Rank
FROM pupilable1
LEFT JOIN pupilable2
ON pupilable1.Pupil_ID = pupilable2.Pupil_ID;

LEFT OUTER JOIN

SELECT pupilable1. Pupil_name, pupilable1.State, pupilable2. Branch, pupilable2.Rank
FROM pupilable1
LEFT OUTER JOIN pupilable2
ON pupilable1.Pupil_ID = pupilable2.Pupil_ID;

Execute the following code

SELECT *
FROM Member
     LEFT OUTER JOIN Branchs ON Member.MemberID = Branchs.MemberID

Examples of ISO/ANSI LEFT OUTER JOIN queries

SELECT *
FROM (table1 LEFT OUTER JOIN (table2 LEFT OUTER JOIN table3 ON table2.casetable1=table3.casetable1)
   ON table1.casetable1=table3.casetable1) JOIN (table4 LEFT OUTER JOIN table5 ON table4.casetable1=table5.casetable1)
   ON table1.casetable1=table4.casetable1;

SELECT *
FROM (table1 LEFT OUTER JOIN (table2 LEFT OUTER JOIN table3 ON table2.casetable1=table3.casetable1) 
   ON table1.casetable1=table3.casetable1), 
   (table4 LEFT OUTER JOIN table5 ON table4.casetable1=table5.casetable1)
   WHERE table1.casetable1 = table4.casetable1;

SELECT *
FROM (table1 LEFT OUTER JOIN (table2 LEFT OUTER JOIN table3 ON table2.casetable1=table3.casetable1)
   ON table1.casetable1=table3.casetable1) LEFT OUTER JOIN (table4 JOIN table5 ON table4.casetable1=table5.casetable1)
   ON table1.casetable1=table4.casetable1;

SELECT *
FROM table1 LEFT OUTER JOIN (table2 LEFT OUTER JOIN table3 ON table2.casetable1=table3.casetable1)
   ON table1.casetable1=table2.casetable1;

SELECT *
FROM table1 LEFT OUTER JOIN (table2 LEFT OUTER JOIN table3 ON table2.casetable1=table3.casetable1)
   ON table1.casetable1=table3.casetable1;

SELECT *
FROM (table1 LEFT OUTER JOIN table2 ON table1.casetable1=table2.casetable1)
   LEFT OUTER JOIN table3 ON table2.casetable1=table3.casetable1;

SELECT *
FROM (table1 LEFT OUTER JOIN table2 ON table1.casetable1=table2.casetable1)
   LEFT OUTER JOIN table3 ON table1.casetable1=table3.casetable1;

SELECT *
FROM t9, (table1 LEFT JOIN table2 ON table1.casetable1=table2.casetable1),
   (table3 LEFT JOIN table4 ON table3.casetable1=10), table10, table11,
   (table12 LEFT JOIN table14 ON table12.casetable1=100);

SELECT * FROM
  ((SELECT casetable1,c2 FROM table3) AS vtable3(v31,v32)
    LEFT OUTER JOIN
        ( (SELECT casetable1,c2 FROM table1) AS vtable1(vcasetable1,vc2)
        LEFT OUTER JOIN
        (SELECT casetable1,c2 FROM table2) AS vtable2(vc3,vc4)
         ON vtable1.vcasetable1 = vtable2.vc3)
ON vtable3.v31 = vtable2.vc3);

SQL Server Left Outer Join with Examples

CREATE TABLE Organization
(
    OrganizationId TinyInt Identity Primary Key,
    OrganizationName Nvarchar(50) NULL
)
GO
INSERT Organization VALUES('PAKAINFO')
INSERT Organization VALUES('INFINITYKNOW')
INSERT Organization VALUES('4CGANDHI')
INSERT Organization VALUES('EXAMPLE')
GO
CREATE TABLE Applicant
(
    ApplicantId tinyint identity primary key,
    FullName nvarchar(50) NULL,
    OrganizationId tinyint REFERENCES Organization(OrganizationId)
)
GO
INSERT Applicant VALUES('Rahul',1)
INSERT Applicant VALUES('Gandhi',2)
INSERT Applicant VALUES('Deepak',3)
INSERT Applicant VALUES('Bravo',NULL)
INSERT Applicant VALUES('Vijay',1)
INSERT Applicant VALUES('Bhoomi',3)
INSERT Applicant VALUES('Shital',NULL)
GO

Example

SELECT App.ApplicantId, App.FullName, App.OrganizationId, Org.OrganizationId, Org.OrganizationName
FROM Applicant App
LEFT OUTER JOIN Organization Org
ON App.OrganizationId = Org.OrganizationId

I hope you get an idea about sql left outer join.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Leave a Reply

Your email address will not be published. Required fields are marked *

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype