Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: UNION Operator

Monday, February 16, 2015

SQL: UNION Operator

The UNION operator combines two or more SELECT statements into one result set. The SELECT list must be the same in all queries, same columns, expressions, functions, and data types. All UNION queries can be replaced with a join query. The query below combines the Customers select statement with with the Employees statement

SELECT City,Address
FROM Customers
UNION
SELECT City,Address
FROM Employees



Here is the result:







6 comments:


  1. When exploring options for bulk transfer services, many businesses turn to reputable providers to ensure quality and efficiency. One such reliable choice is dtf transfers wholesale, which offers comprehensive solutions tailored to commercial needs. Their commitment to customer satisfaction and competitive pricing make them a popular option in the industry. For those interested in streamlining their transfer processes, considering dtf transfers wholesale could be highly beneficial.

    ReplyDelete

  2. When exploring various customization options for your apparel, considering the quality of the design is essential. For high-quality results, you might want to try a dtf printing design that offers vibrant colors and durability. This method ensures that your prints will last wash after wash, making it perfect for both personal projects and commercial use. With the right techniques, you can achieve professional-looking results that stand out.

    ReplyDelete