HOME > �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ和�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽs�ｿｽﾂ具ｿｽ (2008/3/1) MySQL 5.0 / Windows XP
�ｿｽa�ｿｽ�ｿｽ�ｿｽ�ｿｽ
employees
employees2
| id | name | department |
|---|---|---|
| 1 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 1 |
| 2 | �ｿｽR�ｿｽc | 2 |
| 3 | �ｿｽ�ｿｽ�ｿｽ | 3 |
| 4 | �ｿｽ�ｿｽ�ｿｽc | 1 |
| 5 | �ｿｽ�ｿｽ�ｿｽc | 2 |
| 6 | �ｿｽ�ｿｽ�ｿｽ{ | 5 |
| id | name | department |
|---|---|---|
| 1 | �ｿｽ�ｿｽ�ｿｽ | 1 |
| 2 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 2 |
| 3 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 3 |
| 4 | �ｿｽ�ｿｽ�ｿｽ | 1 |
| 5 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 2 |
| 6 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 5 |
�ｿｽ�ｿｽ�ｿｽ@
select * from �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽA union select * from �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽB
�ｿｽ�ｿｽ
select name,department from employees union select name,department from employees2;
�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽﾌペ�ｿｽ[�ｿｽW�ｿｽﾌト�ｿｽb�ｿｽv
�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ搾ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ PREVIOUS
�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ趣ｿｽ�ｿｽﾈ鯉ｿｽ�ｿｽ�ｿｽ NEXT
HOME > �ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ和�ｿｽ�ｿｽ�ｿｽ�ｿｽ