SQL Select - Appending rows from one table to another

tmajor99
tmajor99 used Ask the Experts™
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial