unqualified CROSS JOIN inner qualified outer LEFT RIGHT
- Slides: 8
Явные операции соединения unqualified CROSS JOIN inner qualified outer LEFT RIGHT FULL …… from таблица 1 < …JOIN> таблица 2 ON USING NATURAL
Примеры Persona ID 1 2 3 4 NAME Иванов Петров Сидоров Пупкин BD 01. 1965 10. 04. 1962 24. 05. 1970 29. 02. 1960 Working ID ID_F STATUS 1 25 boss 2 115 teacher 3 2 manager 5 2 worker 1 2 programmer SELECT Persona. Name, Persona. BD, working. status from Persona JOIN Working using (ID) order by Persona. Name NAME Иванов Петров Сидоров BD 01. 01. 1965 10. 04. 1962 24. 05. 1970 STATUS boss programmer teacher manager
Примеры Persona ID 1 2 3 4 NAME Иванов Петров Сидоров Пупкин BD 01. 1965 10. 04. 1962 24. 05. 1970 29. 02. 1960 Working ID ID_F STATUS 1 25 boss 2 115 teacher 3 2 manager 5 2 worker 1 2 programmer SELECT Persona. Name, Persona. BD, working. status from Persona LEFT JOIN Working using (ID) order by Persona. Name NAME Иванов Петров Пупкин Сидоров BD 01. 01. 1965 10. 04. 1962 29. 02. 1960 24. 05. 1970 STATUS boss programmer teacher <NULL> manager
Примеры Persona ID 1 2 3 4 NAME Иванов Петров Сидоров Пупкин BD 01. 1965 10. 04. 1962 24. 05. 1970 29. 02. 1960 Working ID ID_F STATUS 1 25 boss 2 115 teacher 3 2 manager 5 2 worker 1 2 programmer SELECT Persona. Name, Persona. BD, working. status from Persona RIGHT JOIN Working using (ID) order by Persona. Name NAME Иванов Петров Сидоров <NULL> BD 01. 01. 1965 10. 04. 1962 24. 05. 1970 <NULL> STATUS boss programmer teacher manager worker
Примеры Persona ID 1 2 3 4 NAME Иванов Петров Сидоров Пупкин BD 01. 1965 10. 04. 1962 24. 05. 1970 29. 02. 1960 Working ID ID_F STATUS 1 25 boss 2 115 teacher 3 2 manager 5 2 worker 1 2 programmer SELECT Persona. Name, Persona. BD, working. status from Persona FULL JOIN Working using (ID) order by Persona. Name NAME Иванов Петров Пупкин Сидоров <NULL> BD 01. 01. 1965 10. 04. 1962 24. 05. 1970 29. 02. 1960 <NULL> STATUS boss programmer teacher <NULL> Manager worker
Примеры Persona ID 1 2 3 4 NAME Иванов Петров Сидоров Пупкин BD 01. 1965 10. 04. 1962 24. 05. 1970 29. 02. 1960 Working ID ID_F STATUS 1 25 boss 2 115 teacher 3 2 manager 5 2 worker 1 2 programmer SELECT Persona. Name, Persona. BD, working. status from Persona CROSS JOIN Working order by Persona. Name
NAME BD STATUS --------------------Ivanov 01 -JAN-65 worker Ivanov 01 -JAN-65 manager Ivanov 01 -JAN-65 teacher Ivanov 01 -JAN-65 boss Ivanov 01 -JAN-65 programer Petrov 10 -APR-62 worker Petrov 10 -APR-62 manager Petrov 10 -APR-62 teacher Petrov 10 -APR-62 boss Petrov 10 -APR-62 programer Pupkin 29 -FEB-60 worker NAME BD STATUS --------------------Pupkin 29 -FEB-60 manager Pupkin 29 -FEB-60 teacher Pupkin 29 -FEB-60 boss Pupkin 29 -FEB-60 programer Sidorov 24 -MAY-70 worker Sidorov 24 -MAY-70 manager Sidorov 24 -MAY-70 teacher Sidorov 24 -MAY-70 boss Sidorov 24 -MAY-70 programer
