Make one list from 2 unique quiries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 columns that I want to return a single list of unique values.

I'm using the query in a combobox of a form.

example

Table 1
Column 1
apple
pear
peach

Table 1
Column 2
apple
grapes
orange
pear

I want to return one list that would be...
apple
grapes
pear
peach
orange

thank you in advance for any input....
 
Select Column1 as Fruit from table 1
union
Select Column2 as Fruit from table 1


(might have to try a Union ALL and look at select distinct, btu this shoudl
work)
 
Back
Top