The clause combines UNION data in SQL
in sql, you can combine the same structured data from multiple tables into one query using the union and union all operators.
Tags : sql learning
SELF JOIN in SQL
each join operation must have two tables, but there are cases where you have to perform join on the same table, but you can call this join operation self join.