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:





Previous: SQL: FULL OUTER JOIN
Next: SQL : INSERT SELECT

5 comments:

  1. AnonymousJuly 12, 2025 at 1:29 AM

    6D8466AEAC
    mmorpg oyunlar
    sms onay siteleri
    türk telekom mobil bozum
    güvenilir takipçi satın alma instagram
    kaspersky etkinleştirme kodu

    ReplyDelete
  2. AnonymousOctober 19, 2025 at 11:53 AM

    EFCECDFA3B
    steroid fiyat
    Whatsapp Ücretli Show
    tütün satın al

    ReplyDelete
  3. AnonymousOctober 24, 2025 at 6:49 PM

    DBD4641040
    Görüntülü Show Uygulamaları
    Whatsapp Görüntülü Show Numaraları
    Telegram Görüntülü Show Grupları

    ReplyDelete
  4. AnonymousNovember 26, 2025 at 12:55 AM

    4F82C9E104
    Görüntülü Seks
    Görüntülü Sex
    Whatsapp Ücretli Show

    ReplyDelete
  5. AnonymousFebruary 18, 2026 at 10:34 AM


    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

Subscribe to: Post Comments (Atom)

Search This Blog