A union creates a larger horizontal data set that may have no connection, a join relates two tables that are semantically connected by an index, an append simply adds the contents of one table to the end of another table.