Re: to create a Query with 2 Tables

From: Markus Mortsiefer (mmortsie_at_ford.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 13:34:20 +0200

Hallo

I want to say thank you its working well the only thing I have seen is that
I can now not change the data is there a way I can do this but it allows me
to still change the data even they are in two different tables but the
record will either be in the one or the other table never in both the at the
same time

Best regards

Markus

"Gary Walter" <garylwpleasenospam@wamego.net> wrote in message
news:udh4T8WIEHA.2300@tk2msftngp13.phx.gbl...
>
> "MDW" <anonymous@discussions.microsoft.com> wrote
> > If you columns are in the same order for both tables:
> >
> > SELECT * FROM [Main Table]
> >
> > UNION
> >
> > SELECT * FROM [Purge Table]
>
> PMFBI
>
> If some record erroneously occurs in
> both tables, you won't see that unless
> you use
>
> UNION ALL
>
> (plus it is faster).
>
> And I might want to know where
> each record comes from
>
> SELECT "Main" AS WhichTable, * FROM [Main Table]
> UNION ALL
> SELECT "Purge", * FROM [Purge Table]
>
> Apologies again for butting in.
>
> Gary Walter
>
>