Jump to content

Get info from one table and placing it into another one


mdmartiny
 Share

Recommended Posts

I have two different tables and I am trying to condense them into one table.

 

The structure of the tables is

 

cc

-- ci

-- cc

-- cn

-- alpha_2

 

countries

-- id

-- cn

-- alpha_2

-- alpha_3

 

What I want to do is place the info from the column alpha_2 in the countries table into the alpha_2 column in the cc table.

I have tried inner joins, left joins, Insert and Select index. Everything that I have tried gives me an error message. I do not know what I am doing wrong and I was hoping that someone would be able to give me a hand.

 

I forgot to mention that I want the placement of the alpha_2 column to be based on the cn columns in both tables. So that the information in the alpha_2 column lines up with the right name in the cn column

Edited by mdmartiny
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.