TOP CATEGORIES

×

How left outer join works in SQL?

N

Nishant Lodhi

First of all, We need two tables for more understanding about Joining in SQL; In below there are two tables name mentioned:

LEFT_TABLE (as Table 1) 

RIGHT_TABLE (as Table 2).

LEFT OUTER JOIN IN SQL

Left Outer Join is also known as the Left Join; The Left Outer Join returns all records in the LEFT_TABLE (Table 1) and all the matching records from RIGHT_TABLE (Table 2) in a Database.

0 votes

Your Answer

Email: advertise@gdatamart.com

Donate: To Support US

© 2024 GDATAMART.COM (All Rights Reserved)