merge two columns and sorting in SQL CE
I have these two columns to be merged into Column3 and sorted like the way below (first element from column1 then second element from column2 and so on) by using SQLCE in C#.

     Column1   Column2
     -------   -------
      pear     banana
      apple    pineapple
       .         .
       .         .
       .         .

         Column3
         -------
           pear
           banana
           apple
           pineapple
           .
           .
           .
merge two columns and sorting in SQL CE
===

I have these two columns to be merged into Column3 and sorted like the way below (first element from column1 then second element from column2 and so on) by using SQLCE in C#.

     Column1   Column2
     -------   -------
      pear     banana
      apple    pineapple
       .         .
       .         .
       .         .

         Column3
         -------
           pear
           banana
           apple
           pineapple
           .
           .
           .