trainer right join pokemon on trainer.trainer_type=pokemon.type and trainer.id = 1에서 trainer id=1 인 행들만 반환될까?
-> 아니오, trainer.id이 1이 아닌 행들도 반환된다.

trainer.id가 null값인 행들이 존재한다.
on절에서 조건을 만족하지 못한 포켓몬 행들은 trainer 컬럼들이 null로 채워져서 반환된다.

예시)

trainer_id	trainer_name	trainer_type	id	name	type
NULL	NULL	NULL	2	bulbasaur	grass

실험

1. 데이터 구성

pokemon

create table pokemon (
    id INT auto_increment primary key,
    name varchar(20),
    type varchar(20)
);

trainer

create table trainer (
	trainer_id BIGINT primary key,
    trainer_name varchar(20),
    trainer_type varchar(20)
);

pokemon data

id	name	type
1	pikachu	electric
2	balbusaur	grass
3	pikachu	electric
4	coil	electric

trainer data

trainer_id	trainer_name	trainer_type
1	ash	electric
2	martin	electric
3	hyuaryun	fire

2. 쿼리 실행

select * from trainer right join pokemon
on trainer.trainer_type=pokemon.type
and trainer.id=1

3. 결과

trainer_id	trainer_name	trainer_type	id	name	type
1	ash	electric	1	pikachu	electric
NULL	NULL	NULL	2	bulbasaur	grass
1	ash	electric	3	pikachu	electric
1	ash	electric	4	coil	electric

결론

정확히 trainer.id=1인 행들만 나오기를 원한다면, on 절이 아닌 where절에 조건을 넣어야 한다.
예시:

select * from trainer right join pokemon
on trainer.trainer_type=pokemon.type
where trainer.id=1

참고자료

https://stackoverflow.com/questions/8311096/whats-the-difference-between-where-clause-and-on-clause-when-table-left-join