We help IT Professionals succeed at work.

SQL Select - Appending rows from one table to another

tmajor99
tmajor99 asked
on
Just need to append new rows from one SQL Table to another.   In the example below, I just need to append Table A to Table B.

SQL Table A

FOLID
---------
1234
3333

SQL Table B
FOLID   AttributeID  Name  
--------     --------------    -------
99998   33333333     Test

Expected Results:

SQL Table B
FOLID   AttributeID  Name  
--------     --------------    -------
99998   33333333     Test
1234
3333
Comment
Watch Question

Senior Developer
Commented:
First of all: This makes no senses by the means of a relational normalized model..

But it's a simple INSERT:

INSERT TableB ( FOLID )
  SELECT FOLID FROM TableA; 

Open in new window