SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Zealot Snegolle's Avatar
    Join Date
    Jan 2002
    Location
    localhost
    Posts
    142
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question "UNION" function in MySQL

    I have read that it is possible to join two tables using function UNION
    (select aaaa from xxxx
    union
    select bbbb from yyyy; )
    using SQL language but trying it with MySQL I always get an error, although in the MySQL documentation is written that UNION is supported in the version installed on my PC but there are no examples on how to do it :-(

    Please tell me how to do it.



    Thank you.
    Last edited by Snegolle; Apr 27, 2002 at 14:33.

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    are you using MySQL 4? is this the page you were looking at in the manual: www.mysql.com/doc/U/N/UNION.html?
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •