From: Chris Robinson 

Thanks Ellen! - the UNION statement was what I was after - just me getting the syntax
wrong in the first place :o)

"Ellen K." wrote:

> Ooops.   Make that
>
> SELECT a.emp_no FROM Finance a
> UNION
> SELECT b.emp_no FROM Sales b
>
> On Sun, 11 May 2003 21:29:13 -0700, Ellen K. 
> wrote in message :
>
> >Oh, that's a simple UNION:
> >
> >SELECT a.emp_no FROM Finance
> >UNION
> >SELECT b.emp_no FROM Sales
> >
> >
> >On Fri, 09 May 2003 08:29:33 +0100, Chris Robinson
> > wrote in message
> >:
> >
> >>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.
> >>> >> >
> >>> >> >
> >>> >> >

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