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:
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.
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.