---
title: "Discussion on \"𝟰 𝗦𝗤𝗟 𝗷𝗼𝗶𝗻𝘀 𝗲𝘃𝗲𝗿𝘆 𝘀𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗲𝗻𝗴𝗶𝗻𝗲𝗲𝗿 𝘀𝗵𝗼𝘂𝗹𝗱 𝗸𝗻𝗼𝘄.\" | Hashnode"
description: "Discussion on \"𝟰 𝗦𝗤𝗟 𝗷𝗼𝗶𝗻𝘀 𝗲𝘃𝗲𝗿𝘆 𝘀𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗲𝗻𝗴𝗶𝗻𝗲𝗲𝗿 𝘀𝗵𝗼𝘂𝗹𝗱 𝗸𝗻𝗼𝘄.\". 🔹 INNER JOINReturns only the records that have matching values in both the left and right tables.  \n🔹 LEFT (OUTER) JOINReturns all records from the left table and the matched records from the right table. If no match is found, NULL values are retur..."
url: "https://hashnode.com/posts/8j2fscdwnzem8j2xppcdl58g8j2xtcdl7zwnze28j2xucdmiag8j2xsvcdmipwnzey8j2xvcdmiyg8j2ygpcdl7zwnzez8j2ygfcdmitwnzeu8j2xvcdl7ig8j2xsvcdl7vwnze08j2xtvcdl7vwnzey8j2xsvcdl78g8j2ygpcdl7xwnze88j2ygvcdl7nwnzexipcdl7jwnze78j2xvpcdmiqu/6697628eae19cc8d67e80ead"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [𝟰 𝗦𝗤𝗟 𝗷𝗼𝗶𝗻𝘀 𝗲𝘃𝗲𝗿𝘆 𝘀𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗲𝗻𝗴𝗶𝗻𝗲𝗲𝗿 𝘀𝗵𝗼𝘂𝗹𝗱 𝗸𝗻𝗼𝘄.](https://pradeepvp.hashnode.dev/8j2fscdwnzem8j2xppcdl58g8j2xtcdl7zwnze28j2xucdmiag8j2xsvcdmipwnzey8j2xvcdmiyg8j2ygpcdl7zwnzez8j2ygfcdmitwnzeu8j2xvcdl7ig8j2xsvcdl7vwnze08j2xtvcdl7vwnzey8j2xsvcdl78g8j2ygpcdl7xwnze88j2ygvcdl7nwnzexipcdl7jwnze78j2xvpcdmiqu?utm_source=hashnode&utm_medium=feed)

🔹 INNER JOINReturns only the records that have matching values in both the left and right tables. 🔹 LEFT (OUTER) JOINReturns all records from the left table and the matched records from the right table. If no match is found, NULL values are retur...

Jul 17, 2024 · 1 min read · pradeepvp.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#sql-joins](https://hashnode.com/tag/sql-joins)

## Written by

[PRADEEP VP](https://hashnode.com/@pradeepvp007)

@pradeepvp007 · Bangalore, India

  
[View profile](https://hashnode.com/@pradeepvp007)

Keep Learning

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
