From: Chris Robinson 


--------------484A866B81BB27CE9D734CC4
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hehe - yeh, I might as well give an example anyways (just incase someone here knows
of a more efficient way to do it).  Take tables A and B below, each table contains
the same kind of information (i.e. a field called emp_no).

Table A - Finance         Table B - Sales
    emp_no                        emp_no
      0001                            0004
      0002                            0005
      0003                            0006

Ideally I'd like a query that pulls the information from table 1 and table 2 into
one column.  So, the ideal result would be a list of all employee numbers:

Query Result
    emp_no
      0001
      0002
      0003
      0004
      0005
      0006

It doesn't look to hard but selecting each field from each table just gives you a
result that has 2 columns - one contains the emp_no's from table A and the other,
the emp_no's from table B.

Chris.

Ellen K wrote:

> Not sure how I missed your original post, sorry.
>
> Glad you accomplished what you wanted, because from your description I can't
> figure out what that was!!!!
>
> > From: Chris Robinson 
> > Thanks for the tip - it didn't like it though :o(  Instead I created a
macro
> >that wipes a table, adds one set of values to it and then appends the next
set
> > - I then query this table.
> > Everything else just merged the two fields inito one which wasn't what I
was
> > after.
> > Thanks anyway,
> > Chris.
> > Adam Flinton wrote:
> >> Union possibly union all.
> >>
> >> I think Access'es SQL supports Union but I haven't a copy to hand....
> >>
> >> If you want just unique records then do a select distinct
> >>
> >> Adam
> >>
> >> Chris Robinson wrote:
> >> > Is this the right place to post this? I hope so.
> >> >
> >> > I'm writing a database in Access 2000 atm and I was
hoping to get a bit
> >> > of an SQL pointer.  It's probably an easy one although I
can't think of
> >> > a way to do it in a query atm.
> >> >
> >> > I have two tables (X and Y), each with a column that
contains a 4 digit
> >> > code.  I want to create a query that brings the data
from these TWO
> >> > columns into ONE column.  I don't want to merge the data
- it's more a
> >> > case of take the values from table X and append the
values from table Y.
> >> >
> >> > The nearest I got was:
> >> >
> >> > SELECT (xTBL.code & yTBL.code) AS code_list
> >> > FROM xTBL, yTBL;
> >> >
> >> > This actually does merge the fields of the two tables
though (i.e. both
> >> > field values in one field)  I tried GROUPBY's and SELECT
DISTINCT but my
> >> > SQL skills aren't exactly up there.  The next thing I'm
thinking of is
> >> > doing, if this can't be done this way, is an add query
(to a table) for
> >> > the xTBL field and then an append query to the same
table for the yTBL
> >> > field.
> >> >
> >> > Thanks in advance,
> >> > Chris.
> >> >
> >> >
> >> >

--------------484A866B81BB27CE9D734CC4
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



hehe - yeh, I might as well give an example anyways (just incase someone
here knows of a more efficient way to do it).  Take tables A and B
below, each table contains the same kind of information (i.e. a field
called emp_no).
Table A -
Finance        
Table B - Sales
   
emp_no        &n
bsp;            &nb
sp; 
emp_no
     
0001      &nbs
p;             
;       
0004
     
0002      &nbs
p;             
;       
0005
     
0003      &nbs
p;             
;       
0006
Ideally I'd like a query that pulls the information from table 1 and
table 2 into one column.  So, the ideal result would be a list of
all employee numbers:
Query Result
    emp_no
      0001
      0002
      0003
      0004
      0005
      0006
It doesn't look to hard but selecting each field from each table just
gives you a result that has 2 columns - one contains the emp_no's from
table A and the other, the emp_no's from table B.
Chris.
Ellen K wrote:
Not sure how I missed your original post, sorry.
Glad you accomplished what you wanted, because from your description
I can't
figure out what that was!!!!
> From: Chris Robinson <c.robinson{at}NOSPAMtotalise.co.uk>
> Thanks for the tip - it didn't like it though :o(  Instead I
created a macro
>that wipes a table, adds one set of values to it and then appends
the next set
> - I then query this table.
> Everything else just merged the two fields inito one which wasn't
what I was
> after.
> Thanks anyway,
> Chris.
> Adam Flinton wrote:
>> Union possibly union all.
>>
>> I think Access'es SQL supports Union but I haven't a
copy to hand....
>>
>> If you want just unique records then do a select distinct
>>
>> Adam
>>
>> Chris Robinson wrote:
>> > Is this the right place to post this? I hope so.
>> >
>> > I'm writing a database in Access 2000 atm and I was hoping to
get a bit
>> > of an SQL pointer.  It's probably an easy
one although I
can't think of
>> > a way to do it in a query atm.
>> >
>> > I have two tables (X and Y), each with a column that contains
a 4 digit
>> > code.  I want to create a query that
brings the data from
these TWO
>> > columns into ONE column.  I don't want to
merge the data
- it's more a
>> > case of take the values from table X and append the
values from
table Y.
>> >
>> > The nearest I got was:
>> >
>> > SELECT (xTBL.code & yTBL.code) AS code_list
>> > FROM xTBL, yTBL;
>> >
>> > This actually does merge the fields of the two
tables though (i.e.
both
>> > field values in one field)  I tried
GROUPBY's and SELECT
DISTINCT but my
>> > SQL skills aren't exactly up there.  The
next thing I'm thinking
of is
>> > doing, if this can't be done this way, is an add
query (to a table)
for
>> > the xTBL field and then an append query to the same table for
the yTBL
>> > field.
>> >
>> > Thanks in advance,
>> > Chris.
>> >
>> >
>> >


--------------484A866B81BB27CE9D734CC4--

--- BBBS/NT v4.01 Flag-4