# Join Example
__*INNER JOIN*__
+ Show moons for Mars and Jupiter
```
tidb> SELECT 
    -> p.name as planet, m.name as moon
    -> FROM ~!@planets p@!~ 
    -> JOIN ~!@moons m@!~
    -> ON ~!@p.id = m.planet_id@!~
    -> WHERE p.name IN ('Mars', 'Jupiter');
    
+---------+----------+
| planet  | moon     |
+---------+----------+
| Jupiter | Io       |
| Jupiter | Europa   |
| Jupiter | Ganymede |
| Jupiter | Callisto |
+---------+----------+
4 rows in set (0.00 sec)
```

------------------------------------------------------------
```
tidb> EXPLAIN SELECT 
    -> p.name as planet, m.name as moon
    -> FROM planets p 
    -> JOIN moons m
    -> ON p.id = m.planet_id
    -> WHERE p.name IN ('Mars', 'Jupiter');
+-----------------------------+---------+-----------+---------------------------+-----------------------------------------------------------------------+
| id                          | estRows | task      | access object             | operator info                                                         |
+-----------------------------+---------+-----------+---------------------------+-----------------------------------------------------------------------+
| HashJoin_21                 | 2.50    | root      |                           | inner join, equal:[eq(universe.planets.id, universe.moons.planet_id)] |
| ├─IndexReader_25(Build)     | 2.00    | root      |                           | index:IndexRangeScan_24                                               |
| │ └─IndexRangeScan_24       | 2.00    | cop[tikv] | table:p, index:name(name) | range:["Jupiter","Jupiter"], ["Mars","Mars"], keep order:false        |
| └─TableReader_23(Probe)     | 28.00   | root      |                           | data:TableFullScan_22                                                 |
|   └─TableFullScan_22        | 28.00   | cop[tikv] | table:m                   | keep order:false, stats:pseudo                                        |
+-----------------------------+---------+-----------+---------------------------+-----------------------------------------------------------------------+
5 rows in set (0.01 sec)
```