Inserting Two Identical Tables Into One Table

[lhooker]

How can I insert the below "Select" queries results (that works) in to one (1) table.

SELECT Leadership.Name, Leadership.Survey_Taker_Telephone_Number, Leadership.Type, Leadership.Type_Score, Leadership.Contact_Me
FROM Leadership
Union
SELECT Administration.Name, Administration.Survey_Taker_Telephone_Number, Administration.Type, Administration.Type_Score, Administration.Contact_Me
FROM Administration;

 

[pbaldy]

You should be able to use that as the base of an append query.

 

[arnelgp]

the query should look like this:

INSERT INTO anotherTable (
[Name],
[Survey_Taker_Telephone_Number],
[Type], [Type_Score], [Contact_Me] )
FROM
(
SELECT
Leadership.Name,
Leadership.Survey_Taker_Telephone_Number,
Leadership.Type,
Leadership.Type_Score,
Leadership.Contact_Me
FROM Leadership
UNION ALL
SELECT
Administration.Name,
Administration.Survey_Taker_Telephone_Number,
Administration.Type,
Administration.Type_Score,
Administration.Contact_Me
)

 

[pbaldy]

There's your fish.

 

[lhooker]

pbaldy,

Fish ?

 

[NauticalGent]

The adage about feeding a man for a day vice for his life.

 

[lhooker]

NauticalGent,

What happened . . .

 

[NauticalGent]

Nothing to be concerned about, truly. Did you try Arnelgp’s code? I am no expert, but it looks like it will work and he is usually right!

 

[lhooker]

Arnelgp,

Did not work, I added 'From Administration', but it did fix the problem.

INSERT INTO anotherTable ( [Name], [Survey_Taker_Telephone_Number], [Type], [Type_Score], [Contact_Me] )
(SELECT Leadership.Name, Leadership.Survey_Taker_Telephone_Number, Leadership.Type, Leadership.Type_Score, Leadership.Contact_Me
FROM Leadership
UNION ALL
SELECT Administration.Name, Administration.Survey_Taker_Telephone_Number, Administration.Type, Administration.Type_Score, Administration.Contact_Me
FROM Administration

 

[lhooker]

Arnelgp,

I did changed 'anotherTable' to another table name.

 

[pbaldy]

pbaldy,

Fish ?

"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime."

 

[lhooker]

pbaldy,,

OK, got it . . . I have my fishing rod. Any takers ?

 

[jdraw]

Try https://www.w3schools.com/sql/sql_union.asp

Check UNION vs UNION ALL

 

[lhooker]

Pat Hartman/jdraw,

Sorry for not responding ! ! ! I've off the forum for a few days. I ended up creating multiple queries and using a macro to call the queries. Thanks for following up ! ! !