개요
- SQL right join, right outer join
- SQL 오른쪽 조인, 오른쪽 외부 조인, 오른쪽 조인, 라이트 조인, 라이트 아우터 조인
- SQL 외부 조인의 한가지
SELECT *
FROM 테이블1 RIGHT JOIN 테이블2
ON 테이블1.컬럼=테이블2.컬럼;
SELECT *
FROM 테이블1 RIGHT OUTER JOIN 테이블2
ON 테이블1.컬럼=테이블2.컬럼;
예시 1
SELECT * FROM employee
|
SELECT * FROM department
|
SELECT * FROM employee RIGHT JOIN department
ON employee.DepartmentID = department.DepartmentID
SELECT A.LastName, B.DepartmentID, B.DepartmentName
FROM employee A RIGHT JOIN department B
ON A.DepartmentID = B.DepartmentID
예시 2
CREATE TABLE Sales (Date date, CountryID int(11), Units int(11));
INSERT INTO Sales (Date, CountryID, Units) VALUES
('2020-01-01', 1, 40),
('2020-01-02', 1, 25),
('2020-01-03', 3, 30),
('2020-01-04', 4, 35);
CREATE TABLE Countries (ID int(11), Country varchar(16));
INSERT INTO Countries (ID, Country) VALUES
(3, 'Panama');
SELECT Sales.*, Countries.Country
FROM Sales RIGHT JOIN Countries
ON Sales.CountryID = Countries.ID