HOME > �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ鯉ｿｽ�ｿｽ�ｿｽ�ｿｽi�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽj
�ｿｽ�ｿｽ�ｿｽs�ｿｽﾂ具ｿｽ (2008/3/1) MySQL 5.0 / Windows XP
�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA�ｿｽﾆテ�ｿｽ[�ｿｽu�ｿｽ�ｿｽB�ｿｽﾌ鯉ｿｽ�ｿｽ�ｿｽ
employees
departments
| id | name | department |
|---|---|---|
| 1 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 1 |
| 2 | �ｿｽR�ｿｽc | 2 |
| 3 | �ｿｽ�ｿｽ�ｿｽ | 3 |
| 4 | �ｿｽ�ｿｽ�ｿｽc | 1 |
| 5 | �ｿｽ�ｿｽ�ｿｽc | 2 |
| 6 | �ｿｽ�ｿｽ�ｿｽ{ | 5 |
| id | department |
|---|---|
| 1 | �ｿｽ�ｿｽ�ｿｽi�ｿｽJ�ｿｽ�ｿｽ |
| 2 | �ｿｽi�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
| 3 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ |
| 4 | �ｿｽL�ｿｽ�ｿｽ |
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽ@
select * from �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA left join �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB on �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA.�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ=�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB.�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ;
�ｿｽ�ｿｽ
select employees.id,name,departments.department from employees left join departments on employees.department=departments.id;
�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽY�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ department �ｿｽ�ｿｽ�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ�ｿｽ NULL
�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽ@
select * from �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA right join �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB on �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA.�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ=�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB.�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ;
�ｿｽ�ｿｽ
select employees.id,name,departments.department from employees right join departments on employees.department=departments.id;
�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽY�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ id name �ｿｽ�ｿｽ NULL
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽ@
select * from �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA inner join �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB on �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA.�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ=�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB.�ｿｽJ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ;
�ｿｽ�ｿｽ
select employees.id,name,departments.department from employees inner join departments on employees.department=departments.id;
�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽ�ｿｽ
NULL �ｿｽl�ｿｽﾌゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌは表�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ�ｿｽB
�ｿｽ�ｿｽ�ｿｽﾌペ�ｿｽ[�ｿｽW�ｿｽﾌト�ｿｽb�ｿｽv
�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌ設抵ｿｽ PREVIOUS
�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ和�ｿｽ�ｿｽ�ｿｽ�ｿｽ NEXT
HOME > �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ鯉ｿｽ�ｿｽ�ｿｽ�ｿｽi�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽj