The following Union Army units and commanders fought in the Battle of Jonesborough of the American Civil War on August 31-September 1 1864. If we SELECT the data from both the table using UNION ALL -- SELECT without ORDER BY SELECT ID Col1 FROM t1 UNION ALL SELECT ID Col1 FROM t2 GO. Sql Union Vs Union All In Sql Server Difference Between Union And Union All 오라클 Sql 오라클 Union Union All Order By 하는 방법