Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

multiple Unions in the same statement

PAscal
2011-05-25
2013-04-15
  • PAscal
    PAscal
    2011-05-25

    Hello,

    select t1.a from T1
    union all
    select t2.b from T2
    union all
    select t3.c from T3

    Multiple Unions in the same sql statement generates a wrong graph.

    Regards
    PAscal

     
  • alxtoth
    alxtoth
    2011-05-25

    Ooops once again. Please use for the moment

    select t1.a from T1
    union all
    (select t2.b from T2
    union all
    select t3.c from T3)

    -Alex

     
  • PAscal
    PAscal
    2011-06-04

    even better (don't have to think to apply it) :

    (
    select t1.a from T1
    union all
    select t2.b from T2
    union all
    select t3.c from T3
    )

    Regards
    PAscal