Simply join two SELECT statements with the UNION keyword to combine the results of two queries into a new table. When working with databases other than Microsoft's SQL Server, check the manual to ...