I have two files: File 1 File 2 If I Join the two files I have data from both files into a single row: Join The Union merges data from two or more subselects into one result set, the data from each of the subselects is kept as a separate row: Union OK, let me give more detail using some example code.