2 Replies Latest reply on Jan 21, 2010 9:20 PM by Steven Hawkins

    UNION with MySQL

    Ram Yelamanchilli Newbie

      UNION with more than two queries is not working with VDB built from MySql tables.

       

      select column1 from table1

      UNION

      select column1 from table2

       

      In the above case it's working.

       

      select column1 from table1

      UNION

      select column1 from table2

      UNION

      select column1 from table3

       

      In this case it's not working. It's working connecting to Oracle though. Any help please??

       

      Regards

       

      Ram