UNION

[Guest]

Problem: I would like to join the results of two queries and insert the
joined data into a table.

Example:

query names = qry1 qry2
field names = trimmed trimmed
data = mike@* *@junkmail.com
paul@* *@mooselake.com

table
field name =trimmed
data = mike@*
paul@*
*@junkmail.com
*@mooselake.com

Note: all fields are text datatypes.

Thanks
Mike Sundman

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

JET SQL:

INSERT INTO table_name (column_name)
SELECT trimmed_column
FROM
[SELECT trimmed_column FROM qry1
UNION
SELECT trimmed_column FROM qry2]. As A

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQdxwf4echKqOuFEgEQKhRQCdF/n5MN0vnN1Rc/u5qglGmiObD0AAoLl/
Otr3d2gCwnEJLAiS5qK2Bea8
=8sDh
-----END PGP SIGNATURE-----

 

[Guest]

Thank You MGFoster

That worked great. I love these groups.

Mike Sundman