SELECT *
FROM mypokemon
INNER JOIN ability
ON mypokemon.number = ability.number;
※ OUTER JOIN은 MySQL 키워드에 없음
SELECT *
FROM mypokemon
LEFT JOIN ability
ON mypokemon.number = ability.number
UNION
SELECT *
FROM mypokemon
RIGHT JOIN ability
ON mypokemon.number = ability.number;