[AccessD] Append Query

Hi Stephen,

Use a union select query.

like: select VoterID, vote FROM electronicVote UNION Select VoterID, vote
FROM paperVote;

Maybe you have to name the columns... and beware the 2 qeuries must have the
same number of output columns..

HTH

Bert-Jan

----- Original Message ----- 
From: "Stephen Bond" <stephen at bondsoftware.co.nz>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, July 20, 2004 10:48 AM
Subject: [AccessD] Append Query


> Results of an election come in two forms, paper and electronic.  One table
for each.  There are 2 fields in each table, the VoterId and the vote
(Yes/No).  A couple of queries have culled out the duplicate voters intra-
and inter-.  The output of these queries therefore consists of a list of
clean electronic votes and a list of clean paper votes.
>
> I want to take these two output and merge them into one list without using
the Maketable/Append approach.  I want the list to be a *query* output.
>
> Any ideas?  I didn't design this scenario, I've been asked along at
party's end ....
>
> Stephen Bond
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com