Gossamer Forum
Home : General : Databases and SQL :

INSERT help? Simple stuff

Quote Reply
INSERT help? Simple stuff
I am my own worst enemy. I have two tables of data in Access 2002 that I want to merge together. I was able to construct a query that generates the desired result - but I cannot build a new table with those results.

I know from reading my little SQL book that I need to use an INSERT statement. But Access no like my attempts at using it.

The two column names for output would be "Station", and "CountryState".

My query thus far:

Code:


SELECT Stations.StationName AS Station, [Listbox-StateCountry].StationStateCountry AS StateCountry
FROM [Listbox-StateCountry] INNER JOIN Stations ON [Listbox-StateCountry].ID=Stations.StateCountry_ID
UNION
SELECT Airfieldname.Name as Station, Airfieldstate.StateCode AS StateCountry
FROM Airfieldstate INNER JOIN Airfieldname ON Airfieldstate.ID = Airfieldname.Airfieldstate_ID;


Any help appreciated.
Quote Reply
Re: [ArmyAirForces] INSERT help? Simple stuff In reply to
In the SQL design window, there is an option to "merge tables"...I can't find it this second, but I believe the option is in the toolbar.
========================================
Buh Bye!

Cheers,
Me