• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MS Access SQL Question

J

jskushawah

New Member
I have a database named country which contains two tables named Country and Continent.

I want to merge both tables data in a new table named Region, kindly suggest me which query will work to do this operation?
 
jskushawah if you run a query with both tables in it you will get a new table with all content, you may have to rename a field if both tables have same. can not do more on this as there are many Access sites around and this site is for Excel question
 
The union operator can produce a list of all countries and continents in your other tables. It would be something like


SELECT CountryName as RegionName from Country UNION select ContinentName from Continent


This will provide a view.


Also see http://www.w3schools.com/sql/sql_union.asp
 
You must log in or register to reply here.
Back
Top