---
title: "what is left join?"  
description: "what is left join?"  
author: "Amit Singh"  
published: 2010-10-25  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/181/what-is-left-join  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# what is left join?

The LEFT JOIN keyword returns all rows from the left table ( even if there are no matches in the right table ) and matching column of right table.\

## Answers

### Answer by Pushpendra Singh

The LEFT JOIN keyword returns all rows from the left table ( even if there are no matches in the right table ) and matching column of right table.\


---

Original Source: https://www.mindstick.com/interview/181/what-is-left-join

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.