1JOIN combines the ROWs, we will have longer rows at the end.
2We are joining the rows from two or more related tables.
3
4UNION combines the COLUMNs, we will have longer columns at the end.
5UNION combine two different query.
6We are joining the columns from two or more related tables.
7Can be non related tables but queries must select same column names
8with same data type.
1JOIN combines the ROWs, we will have longer rows at the end.
2We are joining the rows from two or more related tables.
3
4UNION combines the COLUMNs, we will have longer columns at the end.
5UNION combine two different query.
6We are joining the columns from two or more related tables.
7Can be non related tables but queries must select same
8column names with same data type.