SELECT fruit FROM table1
UNION
SELECT some_col FROM table2