CROSS JOIN Select from T 1 cross join
- Slides: 9
Декартово произведение (CROSS JOIN) Select * from T 1 cross join T 2
Операции с множеством строк Объединение множеств строк SELECT * from T 1 UNION Select * from T 2 SELECT * from T 1 UNION ALL Select * from T 2 Вычитание множеств строк SELECT * from T 1 MINUS Select * from T 2 Пересечение множеств строк SELECT * from T 1 INTERSECT Select * from T 2
Скрипты примеров create table T 1(T 1_ID INTEGER); create table T 2(T 2_ID INTEGER); insert into T 1 values (1); insert into T 1 values (2); insert into T 1 values (3); insert into T 2 values (2); insert into T 2 values (3); insert into T 2 values (4); select * from T 1; select * from T 2; select * from T 1 cross join T 2; select * from T 1 inner join T 2 on (T 1. T 1_ID = T 2_ID); select * from T 1 left outer join T 2 on (T 1. T 1_ID = T 2_ID); select * from T 1 right outer join T 2 on (T 1. T 1_ID = T 2_ID); select * from T 1 full outer join T 2 on (T 1. T 1_ID = T 2_ID); SELECT * from T 1 UNION ALL Select * from T 2; SELECT * from T 1 MINUS Select * from T 2; SELECT * from T 1 INTERSECT Select * from T 2
