Product
Business Intelligence Self-service analytics for your team Embedded Analytics Fast, flexible customer-facing analytics
Data Studio New Curate your semantic layer Metabase AI Metabot, MCP server and CLI Data Apps Beta Apps on numbers you trust
Data sources 20+ databases and warehouses Security SSO, 2FA, row-level security Cloud Regional hosting, managed by us
Features
Dashboards and reporting
Query builder
SQL editor
Drill-through
CSV upload
Embedded analytics SDK
White-label analytics
Data segregation
Permissions
Usage analytics
New Metabase 65: Data apps, AI Research, and more
Docs
Documentation

The Metabase manual

Learn

Guides and tutorials

Getting Started

Querying and Dashboards

Everyone exploring and analyzing data

Embedding

Developers building in-product analytics

Administration

People running their company’s instance

Guides Installing Metabase Adding a database Asking questions Creating a dashboard Solving common problems
Resources
Blog

News, updates, and ideas

Events

Join a live event or watch on demand

Customers

Real companies, real data, real stories

Discussion

Share and connect with other users

Professional Services

Extra help from our team

Metabase Experts

Find a local expert

Recent Blog Posts
From Toronto Hackathon to Stockholm meetup: Metabase Data App world tour
'Wait, you don't have a semantic layer yet?' AI analytics readiness pulse As humans write less code: workloads shift from human to agent verification with iterative test suites We don't use PHP Making pivot tables faster with GROUPING SETS
Pricing
Business Intelligence pricing

Self-service analytics for your team

Embedded Analytics pricing

Fast, flexible customer-facing analytics

50.2k Log in Get started
Use cases
Business Intelligence Self-service analytics for your team Embedded Analytics Fast, flexible customer-facing analytics
Platform Data Studio New Metabase AI Data Apps Beta Data sources Security Cloud
Dashboards and reporting
Query builder
SQL editor
Drill-through
CSV upload
Embedded analytics SDK
White-label analytics
Data segregation
Permissions
Usage analytics
New Metabase 65: Data apps, AI Research, and more
Documentation

The Metabase manual

Learn

Guides and tutorials

Getting Started

Querying and Dashboards

Everyone exploring and analyzing data

Embedding

Developers building in-product analytics

Administration

People running their company’s instance

Guides Installing Metabase Adding a database Asking questions Creating a dashboard Solving common problems
Blog
Events
Customers
Discussion
Professional Services
Metabase Experts
Business Intelligence pricing

Self-service analytics for your team

Embedded Analytics pricing

Fast, flexible customer-facing analytics

Log in 50.2k on GitHub
Courses
    • Basic concepts
    • Ask a business question
    • Find data
    • Ask a question
    • Create a dashboard
    • Explore dashboards
    • Filter and limit data
    • Summarize data
    • Add custom columns
    • Use dashboard filters
    • Build models
Metabase tutorials
    • A tour of Metabase
    • Advanced Metabase features for data analysts
    • Beyond BI: other problems you can solve with Metabase
      • Custom expressions
      • Joins in Metabase
      • Combining data from different databases
      • Multi-level aggregation
      • Searching in tables
      • Cleaning and formatting text
      • Which chart should you use?
      • Ordering bars in a chart
      • BI dashboard best practices
      • Linking filters
      • Custom click destinations
      • Cross-filtering
      • Build a record lookup tool with Metabase
      • Create filters using SQL variables
      • Field filters for SQL questions
      • Use SQL Snippets
      • Snippets vs. Saved Questions vs. Views
      • Adding filters to dashboards with SQL questions
      • Overview of time series analysis
      • Period-over-period comparisons for time series
      • Best practices for visualizing time series
    • Build a basic CRUD app with actions
    • Using Metabase with MongoDB
      • Admin overview
      • How Metabase works with your database
      • How to run Metabase in production
      • Managing people in Metabase
      • Guide to sharing data
      • Keeping your analytics organized
      • Tutorial: Multiple environments
      • Using serialization
      • Git-based workflow
      • Making dashboards faster
      • Metabase at scale
      • Metabase for data engineers
      • Working with the Metabase API
      • Permissions strategies
      • Data permissions
      • Collection permissions
      • Row-level permissions
      • Column-level permissions
      • Use cases for row and column security
      • How to keep tabs on your data
      • Using LDAP for authentication and access control
Grow your data skills
      • Introduction
      • SQL querying tables
      • SQL filtering by text
      • SQL filtering by date
      • Combining tables with joins
      • SQL join types
      • Combining tables with SQL UNION
      • Best practices for writing SQL queries
      • Common Table Expressions (CTEs) in SQL
      • Working with dates in SQL
      • How to calculate customer lifetime value (LTV) with SQL
      • SQL syntax reference
      • Debugging SQL syntax errors
      • Debugging SQL query logic
      • Debugging duplicated data in SQL query results
      • Debugging missing data in SQL query results
    • A short overview of databases
    • Data types and metadata
    • Database table relationships
    • Measures and dimensions
    • Fact and dimension tables
    • Data normalization
    • What is a database view?
    • Query performance tuning
    • Data cubes
    • A guide to the data landscape
    • Types of databases
    • Data warehouse vs data lake vs data mart
    • Which data warehouse should you use?
    • ETLs, ELTs, and Reverse ETLs
    • Why you should regularly edit your dashboards
    • Managing your information budget
    • Don't use "data" as a crutch for lazy thinking
    • Common data model mistakes made by startups
    • Ten common analytics mistakes startups make
    • The five stages of embedding grief
    • The push and pull of analytics
    • Cumulative charts to track values over time
    • How to do funnel analysis
    • Discover trends in your data
    • How correlation works
    • How tables differ between spreadsheets and databases
    • From VLOOKUP/XLOOKUP to Joins
Cheat sheets
  • Claude skill for learning Metabase
  • Which chart to use?
  • Which map to use?
  • SQL cheat sheet
    • Power BI to Metabase
    • Tableau to Metabase
    • Looker to Metabase
  1. Home
  2. Learn SQL
  3. Combining tables with SQL
  1. Home
  2. Learn SQL
  3. Combining tables with SQL

Combining tables with SQL

Learn how to combine tables with SQL.

Combining tables with joins

How to combine information from two tables with a join.

6 min read

SQL join types

Learn everything you need to know about using different SQL join types.

7 min read

Combining tables with SQL UNION

How to combine rows from two tables using SQL UNION.

15 min read

Product
  • Watch Demo
  • Data Sources
  • Security
  • Cloud
  • Roadmap
  • What’s New
Pricing
  • Plans
  • Open Source
Use cases
  • Self-Service BI Self-Service Business Intelligence
  • Embedded Analytics
  • Data Apps Beta
Metabase plans +
  • Starter and Open Source
  • Pro
  • Enterprise
Features +
  • Metabase AI
  • Query Builder
  • Drill Through
  • Collections
  • Dashboards and reporting
  • SQL editor
  • Permissions
  • Embedded analytics SDK
Company
  • Jobs We’re hiring!
  • Privacy Policies
  • Terms of Service
  • License
  • Brand Guidelines
Support +
  • Documentation
  • Help
  • Professional Services
  • Status
Resources
  • Case Studies
  • Blog
  • Learn
  • Community Stories
  • Partners
  • Example Dashboards
Comparisons +
  • Metabase vs. Tableau
  • Metabase vs. Looker
  • Metabase vs. Looker Studio
  • Metabase vs. PowerBI
  • Metabase vs. Superset
  • Metabase vs. Omni
© Metabase 2026