# Improve Efficiency of Inner Join

## Background

I search the data on Stack Exchange Data Explorer.

## Problem

I want to select columns from two tables and join them to form one single table. I choose INNER JOIN to avoid seeing null entries in the result. The syntax is similar to the following.

Unluckily, when the size of Table1 and Table2 is large, it takes a while to get the result.

## Solution

This page has two more efficient ways. Since I search for recent data, I adopted the third method in my query.