Union and Append in 1 Query?

[Guest]

I am new to SQL, but below is a Union Query I have:

SELECT 1StoreEOHCross.* FROM 1StoreEOHCross;
Union SELECT 1StoreEOOCross.* FROM 1StoreEOOCross;
Union SELECT 1StoreEOHEOOCross.* FROM 1StoreEOHEOOCross;
Union Select 1StoreSlsQtyCross.* FROM 1StoreSlsQtyCross;
UNION Select 1StoreNetSlsCross.* FROM 1StoreNetSlsCross;
UNION select 1StoreEOHEOOTTL.* from 1StoreEOHEOOTTL;
Union select 1StorenetSlsTTL.* from 1StorenetSlsTTL;
UNION select 1StoreSlsTTL.* from 1StoreSlsTTL;


I would like to be able to make this Union Query and append a table with it.
I would like to append all fields and records any suggestions?

Thanks.

Chris

 

[MGFoster]

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

You really need a column list in the SELECT clause and, below, in the
destination column list, to ensure the correct data goes into the
correct columns. Use the column names from the first SELECT command in
the UNION (1StoreEOHCross).

INSERT INTO table_name (<destination column list>)
SELECT <column list>
FROM
[SELECT 1StoreEOHCross.* FROM 1StoreEOHCross
Union SELECT 1StoreEOOCross.* FROM 1StoreEOOCross
Union SELECT 1StoreEOHEOOCross.* FROM 1StoreEOHEOOCross
Union Select 1StoreSlsQtyCross.* FROM 1StoreSlsQtyCross
UNION Select 1StoreNetSlsCross.* FROM 1StoreNetSlsCross
UNION select 1StoreEOHEOOTTL.* from 1StoreEOHEOOTTL
Union select 1StorenetSlsTTL.* from 1StorenetSlsTTL
UNION select 1StoreSlsTTL.* from 1StoreSlsTTL]. 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/AwUBQdxxmYechKqOuFEgEQJE9QCfSERHqWkjlcG/trABqB5gQeGLPfEAoJ7y
lfMqlmY0x5BdAnzB2/oq6CWz
=hYJL
-----END PGP SIGNATURE-----