---
title: "Take your SQL from Good to Great: Part 3"
url: https://daily.dev/posts/take-your-sql-from-good-to-great-part-3-w7kot5q6
source_url: https://towardsdatascience.com/take-your-sql-from-good-to-great-part-3-687d797d1ede
type: article
source: "Towards Data Science"
published: 2021-06-02T15:23:11.944Z
updated: 2021-10-07T14:17:10.317Z
tags: ["sql"]
reading_time: 6
upvotes: 10
comments: 2
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Take your SQL from Good to Great: Part 3

**[Towards Data Science](https://daily.dev/sources/tds)** · 6 min read · 10 upvotes · 2 comments

## Summary

Inner JOIN is a way to join two tables based on some time logic. Range JOINs are a more refined way to merge two tables together. Lateral joins allow you to access columns after the FROM statement. BigQuery uses implicit Lateral Joins via a UNNEST tool.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://towardsdatascience.com/take-your-sql-from-good-to-great-part-3-687d797d1ede>

## Community discussion

Top comments from developers on daily.dev.

**@arthur\_rhc** · 2 upvotes

> Sql execution order, which is excellent for sql tuning

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments
- [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments
- [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments

---

Tags: [#sql](https://daily.dev/tags/sql)

[View this post on daily.dev](https://daily.dev/posts/take-your-sql-from-good-to-great-part-3-w7kot5q6)