Hi anyone here knows how to combine the two columns in a table with the same data type: varchar(255).
When you query the example below:
Code:
Vegetable               Fruits
Potato                  NULL
Squash                  NULL
Cabbage                 NULL
NULL                    Apple
NULL                    Banana
NULL                    Mango
The Result will be:

Code:
Foods
Potato
Squash
Cabbage
Apple
Banana
Mango
Is it possible? Thanks in advance