Left join in SQL and DBMS

Left join shows all rows from the left table and shows only matching rows from the right table.

Table: Exams

Inner join shows results from both tables where there is any match between columns in both tables.

Table: Accounts

Now, we have two different tables. If we want to show the record of both tables in one single table then we can use a left join to join both two tables.

Query of left join

SELECT Exams.RegistrationNo, Exams.Marks, Accounts.Fee FROM Exams LEFT JOIN Accounts ON Exams.RegistrationNo =  Accounts.RegistrationNo

Table: Table generated after Left Join

1. Left join shows some rows from left table ? YES / NO

2. Left join shows all rows from Right table? YES / NO

3. SELECT Exams.Marks, Accounts.Fee FROM Exams LEFT JOIN Accounts?

In this query, exams are the right table and accounts is the left the table.

Yes/No

Topic Covered

Left join in SQL and DBMS.

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.
[email protected] Facebook Linkedin Youtube