By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,009 Members | 2,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,009 IT Pros & Developers. It's quick & easy.

How to append new data (column) in an existing table?

P: 91
When I am appending new data to an empty existing field in an existing table, the data is being added after the last record (row) in the table.

I would like to place the data in a "side-by-side" manner.

I am using SELECT INTO AND INNER JOIN SQL to append the data.

Eg, the after running the query the table looks like.

col1 | col2 | col3
-----|------|--------
a |b |
c |d |
e |f |
| |g
| |h

I would like to place g,h... in col3 from row1 beside b,d....

Is there any ways to do this? I am also attaching the screen shots.
Looking forward for your suggestions.
Attached Files
File Type: doc append.doc (235.0 KB, 272 views)
File Type: pdf append.pdf (200.3 KB, 266 views)
Mar 14 '12 #1

✓ answered by NeoPa

Again, JPEGs is the way for showing pictures.

Anyway, you don't use the term APPEND in relation to SQL when your talking about populating fields in existing records. That would be UPDATE (and an UPDATE query). You are simply changing the values of these pre-existing fields to different data.

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,492
Again, JPEGs is the way for showing pictures.

Anyway, you don't use the term APPEND in relation to SQL when your talking about populating fields in existing records. That would be UPDATE (and an UPDATE query). You are simply changing the values of these pre-existing fields to different data.
Mar 14 '12 #2

P: 91
Thanks NeoPa. I realised later that "Update" is the right tool to do this and hence my other query on "Update".
Mar 14 '12 #3

NeoPa
Expert Mod 15k+
P: 31,492
A quick note to that effect may have saved some time then ;-) Never mind. Next time.
Mar 14 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.