Re: Make one list from 2 unique quiries
- From: "JohnFol" <OutlookExpress@xxxxxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 12:45:05 GMT
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)
"stickandrock" <stickandrock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:539727CA-975C-4AFF-B5D6-00EA03137D2E@xxxxxxxxxxxxxxxx
>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....
.
- References:
- Make one list from 2 unique quiries
- From: stickandrock
- Make one list from 2 unique quiries
- Prev by Date: Re: Show last record but group
- Next by Date: Re: sum minutes to hours
- Previous by thread: Make one list from 2 unique quiries
- Next by thread: Show last record but group
- Index(es):
Relevant Pages
|
