---
title: "Discussion on \"Mental Model For SQL Joins\" | Hashnode"
description: "Discussion on \"Mental Model For SQL Joins\". SYNTAX\nSELECT *  \nFROM table1 \nJOIN table2\n    ON table1.id = table2.id;\nJust replace JOIN with LEFT JOIN/ FULL OUTER JOIN, etc if using a different join.\nJoin / Inner Join\n\nloop through each row in table1\nfor each row in table1, loop through table2\n..."
url: "https://hashnode.com/posts/mental-model-for-sql-joins/62a41420a2c282d2d837830b"
---

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

Discussion

# [Mental Model For SQL Joins](https://acdev.hashnode.dev/mental-model-for-sql-joins?utm_source=hashnode&utm_medium=feed)

SYNTAX SELECT \* FROM table1 JOIN table2 ON table1.id = table2.id; Just replace JOIN with LEFT JOIN/ FULL OUTER JOIN, etc if using a different join. Join / Inner Join loop through each row in table1 for each row in table1, loop through table2 ...

Jun 3, 2022 · 2 min read · acdev.hashnode.dev  
Read the article

## Written by

[Albert Chang](https://hashnode.com/@ACDEV)

@ACDEV

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

Front end dev

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
