UNION
Combines results from two queries (removes duplicates).
sql
1SELECT name FROM students
2UNION
3SELECT name FROM teachers;Column counts and types must match.
Combines results from two queries (removes duplicates).
1SELECT name FROM students
2UNION
3SELECT name FROM teachers;Column counts and types must match.