Set operations
- union
- intersect
- except: difference
These combine query results, not tables.
Incorrect:
create table a(a_id int, x int);
create table b(b_id int, y int);
...
-- WRONG
select *
from a union b
Correct:
select * from a
union
select * from b
|