Scribd
Upload
35 views1 page

Left Join Syntax

The document provides SQL syntax for different types of joins: LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. Each join type is explained with its purpose and a corresponding SQL syntax example. LEFT JOIN retrieves all records from the left table, RIGHT JOIN from the right table, and FULL OUTER JOIN from both tables when there is a match.

Uploaded by

Abdul Razzak
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
35 views1 page

Left Join Syntax

The document provides SQL syntax for different types of joins: LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. Each join type is explained with its purpose and a corresponding SQL syntax example. LEFT JOIN retrieves all records from the left table, RIGHT JOIN from the right table, and FULL OUTER JOIN from both tables when there is a match.

Uploaded by

Abdul Razzak
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

LEFT JOIN Syntax:

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name  =  table2.column_name;
RIGHT (OUTER) JOIN: This function returns records from the right table and matched records from the
left table.
RIGHT JOIN Syntax:

SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name  =  table2.column_name;
FULL (OUTER) JOIN: It returns record when there is a match in either left or right table.
FULL OUTER JOIN Syntax:

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name  =  table2.column_name
WHERE condition;

You might also like