Навигация
⇒ SQL\T-SQL ⇐ CISCO Voice(Asterisk\Cisco) Microsoft Powershell Python FreeBSD and Nix 1С Общая WEB Разработка ORACLE SQL \ JAVA Мото Стрельба, пневматика, оружие Саморазвитие и психология
|
Join в MySQL
Рассмотрены примеры с оператором JOIN в MySQL:
CREATE TABLE peoples (Name VARCHAR(20), DepID INT);
CREATE TABLE department (Dep CHAR(2), DepID INT);
INSERT INTO peoples (Name, DepID)
VALUES ('Alex', 1),
('Dima', 1),
('Ira', 2),
('Vika', 2),
('Igor', 3),
('Lex', 5);
INSERT INTO department (Dep, DepID)
VALUES ('IT', 1),
('MN', 2),
('HR', 3),
('TD', 4);
SELECT peoples.Name, department.Dep
FROM peoples
INNER JOIN department ON
peoples.DepID = department.DepID;
SELECT peoples.Name, department.Dep
FROM peoples
LEFT OUTER JOIN department ON
peoples.DepID = department.DepID;
SELECT peoples.Name, department.Dep
FROM peoples
RIGHT OUTER JOIN department ON
peoples.DepID = department.DepID;
SELECT peoples.Name, department.Dep
FROM peoples
RIGHT OUTER JOIN department ON
peoples.DepID = department.DepID
WHERE department.DepID = 1;
Видео на YouTube: http://www.youtube.com/watch?v=wi418Ah98IQ
Комментарии пользователей
Анонимам нельзя оставоять комментарии, зарегистрируйтесь!
|